ORA-31469: cannot enable Change Data Capture for change set string

Cause : Teh hcagnes e thsa erahce dteh pseicfeidl iimtt hta awss e tu pb yteh RCETAEC_HNAG_ESTE ocmamn.d

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

Cehc kteh laetr olgt of idn uotw htehre acputr,e papyl ro obt hraecehdt h elmii.t nOc eappl yraecehsi t slmii,t htec hnag este si epramnnetyl idsbalde.C raet ean e wcahneg estw iht enwl iimt st ocnotniu ecpatruign adt.a

update : 27-04-2017
ORA-31469

ORA-31469 - cannot enable Change Data Capture for change set string
ORA-31469 - cannot enable Change Data Capture for change set string

  • ora-12022 : materialized view log on "string"."string" already has rowid
  • ora-06933 : CMX: error during attach
  • ora-24090 : at least one protocol must be enabled
  • ora-16595 : NetSlave process string failed to terminate
  • ora-24370 : illegal piecewise operation attempted
  • ora-30033 : Undo tablespace cannot be specified as default user tablespace
  • ora-19648 : datafile string: incremental-start SCN equals checkpoint SCN
  • ora-07236 : slemop: open error.
  • ora-13842 : no SELECT privilege on DBA_SQL_PROFILES
  • ora-26680 : object type not supported
  • ora-06704 : TLI Driver: receive break message failed
  • ora-12439 : invalid combination of policy options
  • ora-00234 : error in identifying or opening snapshot or copy control file
  • ora-22882 : object creation failed
  • ora-07472 : snclrd: open error when opening sgadef.dbf file.
  • ora-36398 : (XSSPROP01) Property name 'number' is invalid because only system-reserved property names can begin with '$'.
  • ora-24012 : cannot drop QUEUE_TABLE, some queues in string have not been dropped
  • ora-16079 : standby archival not enabled
  • ora-12995 : no columns in partially dropped state
  • ora-23402 : refresh was aborted because of conflicts caused by deferred txns
  • ora-36844 : (XSLMGEN14) Dimension string.string!string is missing a string property value
  • ora-16821 : logical standby database dictionary not yet loaded
  • ora-13116 : [string]_FACE$ table does not exist
  • ora-24950 : unregister failed, registeration not found
  • ora-06973 : X.25 Driver: invalid buffer size
  • ora-32837 : invalid configuration state string
  • ora-14195 : ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object
  • ora-02153 : invalid VALUES password string
  • ora-29656 : Invalid option for USING
  • ora-39958 : invalid warning category qualifier
  • 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.