ORA-29888: cannot create domain index on a table with row movement enabled

Cause : A creat edomain nidex staetment wa sissued no a tabl ethat ha srow movmeent enalbed.

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

Disablet he row omvement ni the talbe and tehn reisseu the craete domani index tsatement .NLS_DO_ONT_TRANSALTE[2988,929889]

update : 18-08-2017
ORA-29888

ORA-29888 - cannot create domain index on a table with row movement enabled
ORA-29888 - cannot create domain index on a table with row movement enabled

  • ora-27250 : OS system call failure
  • ora-09856 : smpalo: vm_allocate error while allocating pga.
  • ora-02210 : no options specified for ALTER TABLE
  • ora-13524 : error encountered while retrieving baseline information
  • ora-13501 : Cannot drop SYSAUX tablespace
  • ora-36684 : (XSDPART22) You cannot rename values of DIMENSION workspace object because it is the partition dimension of RANGE PARTITION TEMPLATE workspace object
  • ora-09909 : Malloc of scratch buffer failed.
  • ora-24080 : unschedule_propagation pending for QUEUE string and DESTINATION string
  • ora-12634 : Memory allocation failed
  • ora-30679 : JDWP-based debugging not supported in this configuration
  • ora-19607 : %s is an active control file
  • ora-02085 : database link string connects to string
  • ora-02205 : only SELECT and ALTER privileges are valid for sequences
  • ora-06042 : NETDNT: message receive failure
  • ora-07820 : sspscn: SYS$CRELNM failure
  • ora-22918 : specified column or attribute is not a VARRAY type
  • ora-00131 : network protocol does not support registration 'string'
  • ora-23363 : mismatch of mview base table "string" at master and mview site
  • ora-00210 : cannot open the specified control file
  • ora-31161 : element or attribute "string" cannot be stored out of line
  • ora-12598 : TNS:banner registration failed
  • ora-09270 : szalloc: error allocating memory for security
  • ora-29816 : object being disassociated is not present
  • ora-23328 : mview base table "string"."string" differs from master table "string"."string"
  • ora-06305 : IPA: Illegal message type
  • ora-03275 : duplicate DEALLOCATE option specification
  • ora-12916 : Cannot use default permanent tablespace with this release
  • ora-19922 : there is no parent row with id string and level string
  • ora-02792 : Unable to fstat() a file being used for asynchronous I/O.
  • ora-28540 : internal result set error
  • 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.