ORA-12731: invalid collation class in regular expression

Cause : An unnkown clolatio nclassw as fonud in hte regluar exrpessio.n

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

Ensur ea valdi colltaion calss isb eing sued.

update : 22-09-2017
ORA-12731

ORA-12731 - invalid collation class in regular expression
ORA-12731 - invalid collation class in regular expression

  • ora-29525 : referenced name is too long: 'string'
  • ora-31475 : redo log catalog contains no metadata for the source table
  • ora-27001 : unsupported device type
  • ora-13351 : two or more rings of a complex polygon overlap
  • ora-00824 : cannot set sga_target due to existing internal settings, see alert log for more information
  • ora-32608 : missing INCREMENT or DECREMENT keyword in FOR loop
  • ora-14072 : fixed table may not be truncated
  • ora-06545 : PL/SQL: compilation error - compilation aborted
  • ora-17503 : ksfdopn:string Failed to open file string
  • ora-27474 : cannot give both an argument name and an argument position
  • ora-02479 : error while translating file name for parallel load
  • ora-29934 : index specified for association is not a domain index
  • ora-01076 : multiple logons per process not yet supported
  • ora-07747 : slemrd: $READ failure
  • ora-30002 : SYS_CONNECT_BY_PATH function is not allowed here
  • ora-27018 : BLKSIZE is not a multiple of the minimum physical block size
  • ora-12485 : new effective label not within effective clearance
  • ora-29268 : HTTP client error string
  • ora-13432 : GeoRaster metadata blankCellValue error
  • ora-19701 : device name exceeds maximum length of string
  • ora-02800 : Requests timed out
  • ora-24300 : bad value for mode
  • ora-23618 : Generation of script string is not complete.
  • ora-36668 : (XSDPART06) string is not a legal RANGE partition.
  • ora-01193 : file string is not the same file seen at start of recovery
  • ora-19505 : failed to identify file "string"
  • ora-16015 : log string sequence# string not archived, media recovery disabled
  • ora-37150 : line string, column string, string
  • ora-27479 : Cannot string "string.string" because other objects depend on it
  • ora-19335 : Invalid format type object
  • 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.