ORA-29952: cannot issue DDL on a domain index partition marked as LOADING

Cause : Tried to issue a DROP/ALTER/TRUNCATE on a domain index partition in a LOADING state.

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

Wait till the index partition operation completes OR issue a DROP INDEX FORCE to drop the index OR issue a ALTER TABLE DROP PARTITION to drop the partition.

update : 26-09-2017

ORA-29952 - cannot issue DDL on a domain index partition marked as LOADING
ORA-29952 - cannot issue DDL on a domain index partition marked as LOADING

  • ora-30048 : Internal event for IMU auto-tuning
  • ora-28506 : parse error in data dictionary translation for string stored in string
  • ora-19692 : missing creation stamp on piece string
  • ora-27152 : attempt to post process failed
  • ora-22805 : cannot insert NULL object into object tables or nested tables
  • ora-13902 : The specified file string is not a data file.
  • ora-00399 : corrupt change description in redo log
  • ora-12423 : invalid position specified
  • ora-38446 : Error with embedded ADT "string" in the attribute set.
  • ora-29542 : class string already defined by source string
  • ora-14254 : cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table
  • ora-07456 : cannot set RESOURCE_MANAGER_PLAN when database is closed
  • ora-32581 : missing or invalid password
  • ora-12035 : could not use materialized view log on "string"."string"
  • ora-28039 : cannot validate Kerberos service ticket
  • ora-12476 : least upper bound resulted in an invalid OS label
  • ora-39173 : Encrypted data has been stored unencrypted in dump file set.
  • ora-36290 : (EIFMAKEF14) You cannot export object workspace object, because EIFVERSION is set to number. That version does not support dimensions of type NUMBER.
  • ora-23367 : table string is missing the primary key
  • ora-06765 : TLI Driver: error awaiting orderly release
  • ora-06578 : output parameter cannot be a duplicate bind
  • ora-15029 : disk 'string' is already mounted by this instance
  • ora-19753 : error writing to change tracking file
  • ora-03245 : Tablespace has to be dictionary managed, online and permanent to be able to migrate
  • ora-32511 : cannot create watchpoint in memory needed by watchpointing code
  • ora-01316 : Already attached to a Logminer session
  • ora-29533 : attempt to overwrite class or resource string while defining or compiling string.string
  • ora-02315 : incorrect number of arguments for default constructor
  • ora-29935 : missing FROM keyword
  • ora-22980 : must specify a set of attributes for the WITH OBJECT OID clause
  • 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.