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 : 27-06-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-36402 : (XSSPROP03) The property '$string' requires a leading "$" because it is a system-reserved property name.
  • ora-29380 : resource plan string is currently active and cannot be deleted
  • ora-39116 : invalid trigger operation on mutating table string.string
  • ora-02815 : Unable to attach shared memory
  • ora-10637 : The segment does not exist
  • ora-30120 : 'string' is not a legal oracle number for 'string'
  • ora-09204 : sfotf: error opening temporary file
  • ora-30957 : cannot downgrade because there are XML indexes
  • ora-31407 : end_date must be greater than the begin_date
  • ora-03123 : operation would block
  • ora-29397 : cannot grant/revoke switch privilege for string
  • ora-08311 : sllfop: bad value for maxrecsize
  • ora-38441 : System could not derive the list of STORED and INDEXED attributes.
  • ora-31153 : Cannot create schema URL with reserved prefix "http://xmlns.oracle.com/xdb/schemas/"
  • ora-02283 : cannot alter starting sequence number
  • ora-23377 : bad name string for missing_rows_oname1 argument
  • ora-13189 : recursive SQL parse failed
  • ora-28551 : pass-through SQL: SQL parse error
  • ora-28175 : incorrect certificate type
  • ora-29822 : selectivity cannot be specified for the type of object
  • ora-27431 : chain string.string has a user-managed rule set
  • ora-22298 : length of directory alias name or file name too long
  • ora-28528 : Heterogeneous Services datatype conversion error
  • ora-16016 : archived log for thread string sequence# string unavailable
  • ora-28178 : password not provided by proxy
  • ora-31403 : change table string already contains a column string
  • ora-09836 : addCallback: could not add a port to the callback set.
  • ora-36665 : (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.
  • ora-31105 : User does not own lock "string"
  • ora-30511 : invalid DDL operation in system triggers
  • 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.