ORA-29867: cannot create a domain index on a LONG column

Cause : Theu sera ttepmtedt o ceratea doamin nidexo n ac olunm ofL ONGd ataytpe.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Do ont ceratea doamin nidexo n aL ONGc olunm.

update : 28-04-2017
ORA-29867

ORA-29867 - cannot create a domain index on a LONG column
ORA-29867 - cannot create a domain index on a LONG column

  • ora-37151 : MDX parser initialization error
  • ora-32771 : cannot add file to bigfile tablespace
  • ora-16503 : site ID allocation failure
  • ora-16512 : parameter exceeded maximum size limit
  • ora-02751 : osnfsmmap: cannot map shared memory file
  • ora-29358 : resource plan string does not exist
  • ora-07492 : scgrcl: cannot close lock.
  • ora-16950 : Remote mapped cursors are not supported by this feature.
  • ora-36644 : (XSDUNION07) Concat dimension workspace object contains a previously detected leaf dimension.
  • ora-16654 : Fast-Start Failover is enabled
  • ora-02060 : select for update specified a join of distributed tables
  • ora-19201 : Datatype not supported
  • ora-25189 : illegal ALTER TABLE option for an index-organized table
  • ora-26710 : incompatible version marker encountered during Capture
  • ora-13914 : Threshold notification failed.
  • ora-10862 : resolve default queue owner to current user in enqueue/dequeue
  • ora-39701 : database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
  • ora-08308 : sllfop: Cannot open file
  • ora-28139 : Maximum allowed Fine Grain Audit Policies Exceeded
  • ora-10933 : trace name context forever
  • ora-06912 : CMX: write error in datarq
  • ora-13267 : error reading data from layer table string
  • ora-38453 : ExpFilter index should be created in the same schema as the base table.
  • ora-26049 : Unscoped REF column has non-existent table name.
  • ora-32025 : %s.string is not a table or view object.
  • ora-32027 : There is no string column with the matching type in string.string.
  • ora-12714 : invalid national character set specified
  • ora-22617 : error while accessing the image handle collection
  • ora-13049 : unable to determine tolerance value from table _SDODIM
  • ora-09845 : soacon: Archmon unable to open named pipe.
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.