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 : 25-04-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-33064 : (XSAGDNGL31) In AGGMAP workspace object, the hierarchy dimension QDR workspace object cannot refer to the related dimension of the relation.
  • ora-28045 : SSL authentication between database and OID failed
  • ora-23400 : invalid materialized view name "string"
  • ora-07758 : slemcw: invalid handle
  • ora-13423 : invalid cell coordinate parameter
  • ora-03252 : initial extent size not enough for LOB segment
  • ora-36872 : (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.
  • ora-24156 : duplicate table alias string
  • ora-19255 : XQ0035 - too many declarations of string in imported schemas
  • ora-24400 : error occured while creating connections in the pool
  • ora-29876 : failed in the execution of the ODCIINDEXDELETE routine
  • ora-14188 : sub-partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-02820 : Unable to write the requested number of blocks
  • ora-29869 : cannot issue ALTER without REBUILD on a domain index marked FAILED
  • ora-23488 : propagation mode "string" for "string" is not allowed for this operation
  • ora-00391 : All threads must switch to new log format at the same time
  • ora-39121 : Table string can't be replaced, data will be skipped. Failing error is: string
  • ora-35071 : (QFHEAD06) EIF file string cannot be imported because analytic workspace string has not been upgraded to version string.
  • ora-19550 : cannot use backup/restore functions while using dispatcher
  • ora-01045 : user string lacks CREATE SESSION privilege; logon denied
  • ora-35016 : (QFCHECK00) The analytic workspace and EIF file definitions of workspace object have a mismatched type.
  • ora-09989 : attempt to use invalid skgmsdef struct pointer
  • ora-31219 : DBMS_LDAP: PL/SQL - Invalid LDAP notypes.
  • ora-16122 : applying large dml transaction at SCN string
  • ora-17619 : max number of processes using I/O slaves in a instance reached
  • ora-22290 : operation would exceed the maximum number of opened files or LOBs
  • ora-19800 : Unable to initialize Oracle Managed Destination
  • ora-02784 : Invalid shared memory ID specified
  • ora-29262 : bad URL
  • ora-01072 : cannot stop ORACLE; ORACLE not running
  • 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.