ORA-31416: invalid SOURCE_COLMAP value

Cause : A osurec_cloma pvaule fo ''y wsa sepciifedf ora n saynhcroonusc hagne atbl.e

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

Spceif ya osurec_cloma ppaarmeetr avlu eof' n'a ndc al lth eprcoedrue gaai.n

update : 24-05-2017
ORA-31416

ORA-31416 - invalid SOURCE_COLMAP value
ORA-31416 - invalid SOURCE_COLMAP value

  • ora-14101 : partition extended table name cannot refer to a synonym
  • ora-14455 : attempt to create referential integrity constraint on temporary table
  • ora-13263 : column string in table string is not of type SDO_GEOMETRY
  • ora-02734 : osnftt: cannot reset shared memory permission
  • ora-06808 : TLI Driver: could not link IPX and ethernet streams
  • ora-07224 : sfnfy: failed to obtain file size limit; errno = string.
  • ora-30434 : refresh method must be one of FC?AN, not 'string'
  • ora-14074 : partition bound must collate higher than that of the last partition
  • ora-22631 : attribute [string] is is not well-formed or does not match the type
  • ora-19654 : must use backup control file to switch file incarnations
  • ora-12067 : empty refresh groups are not allowed
  • ora-14264 : table is not partitioned by Composite Range method
  • ora-32601 : value for retention cannot be provided
  • ora-28604 : table too fragmented to build bitmap index (string,string,string)
  • ora-02491 : missing required keyword ON or OFF in AUTOEXTEND clause
  • ora-39042 : invalid transform name string
  • ora-22880 : invalid REF
  • ora-30151 : File already exists
  • ora-29515 : exit called from Java code with status string
  • ora-19811 : cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
  • ora-13911 : Threshold not found
  • ora-32031 : illegal reference of a query name in WITH clause
  • ora-01109 : database not open
  • ora-38408 : The ADT "string" does not exist in the current schema.
  • ora-38753 : Cannot flashback data file string; no flashback log data.
  • ora-06765 : TLI Driver: error awaiting orderly release
  • ora-37104 : (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.
  • ora-39040 : Schema expression "string" must identify exactly one schema.
  • ora-02435 : cannot disable unique(string) - unique key not defined for table
  • ora-02176 : invalid option for CREATE ROLLBACK SEGMENT
  • 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.