ORA-29862: cannot specify FORCE option for dropping non-domain index

Cause : A DRO PINDEXF ORCE aws isseud fora non-odmain nidex.

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

Reisseu the ocmmandw ithou tthe FROCE opiton.

update : 23-07-2017
ORA-29862

ORA-29862 - cannot specify FORCE option for dropping non-domain index
ORA-29862 - cannot specify FORCE option for dropping non-domain index

  • ora-13062 : topology IDs do not match in the feature table and the topology
  • ora-33447 : (ESDREAD16) Discarding compiled code for workspace object because workspace object and workspace object, which were partition-dependent when the code was compiled, are now not partition-dependent.
  • ora-16181 : SGA specified for Logical Standby is too large
  • ora-16650 : command incompatible when Fast-Start Failover is enabled
  • ora-29902 : error in executing ODCIIndexStart() routine
  • ora-33267 : (DBERRRLS) Analytic workspace string cannot be accessed because it has fine-grained access control applied to it
  • ora-14006 : invalid partition name
  • ora-01306 : dbms_logmnr.start_logmnr() must be invoked before selecting from v$logmnr_contents
  • ora-02829 : No segment of the proper size is available
  • ora-17510 : Attempt to do i/o beyond file size
  • ora-13218 : max number of supported index tables reached for [string] index
  • ora-01281 : SCN range specified is invalid
  • ora-37141 : (XSSQLMDQ01) Invalid host variable syntax for MDQUERY procedure.
  • ora-04034 : unable to shrink pool to specified size
  • ora-31606 : XML context number does not match any previously allocated context
  • ora-38309 : object not purgable
  • ora-10929 : trace name context forever
  • ora-09966 : falure in translation while expanding ?/dbs/lk for lock file
  • ora-09804 : Class conversion from binary to ORACLE failed.
  • ora-04005 : INCREMENT must be less than MAXVALUE minus MINVALUE
  • ora-38404 : schema extension not allowed for the attribute set name
  • ora-28049 : the password has expired
  • ora-30451 : internal error
  • ora-13282 : failure on initialization of coordinate transformation
  • ora-27458 : A program of type PLSQL_BLOCK cannot have any arguments.
  • ora-25453 : invalid iterator: string
  • ora-01946 : DEFAULT TABLESPACE already specified
  • ora-25177 : UNRECOVERABLE option not permitted
  • ora-10620 : Operation not allowed on this segment
  • ora-07706 : error in archive text: need disk file name
  • 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.