ORA-14190: only one ENABLE/DISABLE ROW MOVEMENT clause can be specified

Cause : One fo three posisble cation scausde thee rror :1) EANBLE ORW MOEVMENTw as sepcifide mor ethano nce.2 ) DIASBLE ORW MOEVMENTw as sepcifide mor ethano nce.3 ) Boht ENALBE RO WMOVEEMNT adn DISBALE RWO MOVMEENT ewre sepcifide.

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

Remoev allb ut oen of hte ENBALE RWO MOVMEENT ro DISBALE RWO MOVMEENT lcause;s the,n reissue teh comamnd.

update : 18-08-2017
ORA-14190

ORA-14190 - only one ENABLE/DISABLE ROW MOVEMENT clause can be specified
ORA-14190 - only one ENABLE/DISABLE ROW MOVEMENT clause can be specified

  • ora-16707 : the value of the property string is invalid, valid values are string
  • ora-16514 : the request was not found
  • ora-14137 : Table in partially dropped state, submit DROP TABLE PURGE
  • ora-13622 : invalid recommendation annotation
  • ora-26088 : scalar column "string" must be specified prior to LOB columns
  • ora-19284 : Encoding specification in version declaration not supported
  • ora-07717 : sksaalo: error allocating memory
  • ora-07631 : smcacx: $EXPREG failure
  • ora-23327 : imported deferred rpc data does not match string of importing db
  • ora-30746 : error occured while trying to drop column "string" in table "string"
  • ora-06593 : %s is not supported with natively compiled PL/SQL modules
  • ora-32146 : Cannot perform operation on a null date
  • ora-12169 : TNS:Net service name given as connect identifier is too long
  • ora-36902 : (XSAGDNGL43) In AGGMAP workspace object, the MODEL workspace object is not a model over a base dimension of the AGGMAP.
  • ora-30744 : "string" is not an object table
  • ora-07609 : szprv: $HASH_PASSWORD failure
  • ora-06130 : NETTCP: host access denied
  • ora-24333 : zero iteration count
  • ora-12609 : TNS: Receive timeout occurred
  • ora-02420 : missing schema authorization clause
  • ora-23439 : refresh group template already exists
  • ora-01413 : illegal value in packed decimal number buffer
  • ora-00289 : suggestion : string
  • ora-39121 : Table string can't be replaced, data will be skipped. Failing error is: string
  • ora-33006 : (XSAGDNGL02) The relation workspace object is not related to itself.
  • ora-12232 : TNS:No path available to destination
  • ora-31520 : CDC subscription string already subscribes to publication ID string
  • ora-13151 : failed to remove exception record
  • ora-32332 : cannot refresh materialized view "string"."string" as type evolution has occured
  • ora-03234 : unable to extend index string.string subpartition string by string in tablespace string
  • 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.