ORA-29884: domain index is defined on the column to be dropped

Cause : An LATERT ABL EDRO PCOLMUN wsa isused no a oclum non hwicha doamin nidexe xisst.

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

Dro pthed omani inedx bfeorea ttepmtin gto rdop hte cloumn.

update : 29-06-2017
ORA-29884

ORA-29884 - domain index is defined on the column to be dropped
ORA-29884 - domain index is defined on the column to be dropped

  • ora-31515 : CDC change source string already exists
  • ora-02738 : osnpwrtbrkmsg: incorrect number of bytes written
  • ora-28546 : connection initialization failed, probable Net8 admin error
  • ora-07271 : spwat: invalid oracle process number.
  • ora-13757 : "SQL Tuning Set" "string" owned by user "string" is active.
  • ora-29329 : Table not of type XMLType
  • ora-28555 : pass-through SQL: required parameter missing or NULL
  • ora-06000 : NETASY: port open failure
  • ora-01251 : Unknown File Header Version read for file number string
  • ora-00203 : using the wrong control files
  • ora-12424 : length exceeds binary label size
  • ora-31071 : Invalid database username or GUID string
  • ora-13203 : failed to read USER_SDO_GEOM_METADATA view
  • ora-16128 : User initiated stop apply successfully completed
  • ora-13122 : invalid topo_geometry specified
  • ora-22957 : NULL is an invalid input to powermultiset and COLLECT functions
  • ora-23531 : site owner already exists in the template.
  • ora-13000 : dimension number is out of range
  • ora-16768 : SQL Apply unexpectedly offline
  • ora-12841 : Cannot alter the session parallel DML state within a transaction
  • ora-29389 : too many errors during validation
  • ora-25184 : column name expected
  • ora-16011 : Archivelog Remote File Server process in Error state
  • ora-14284 : one or more of table's subpartitions reside in a read-only tablespace
  • ora-32035 : unreferenced query name defined in WITH clause
  • ora-31532 : cannot enable change source string
  • ora-12087 : online redefinition not allowed on tables owned by "string"
  • ora-23392 : could not find materialized view to be associated with "string"."string"
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-24770 : cannot forget a prepared transaction
  • 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.