ORA-12723: regular expression too complex

Cause : The regular expression was too complex and could not be parsed.

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

This is an internal error. Contact Oracle Support Services.

update : 24-06-2017
ORA-12723

ORA-12723 - regular expression too complex
ORA-12723 - regular expression too complex

  • ora-15078 : ASM diskgroup was forcibly dismounted
  • ora-16206 : database already configured as Logical Standby database
  • ora-16199 : Terminal recovery failed to recover to a consistent point
  • ora-23463 : flavor incompatible with object "string"."string"
  • ora-03202 : the scan limit specification is invalid
  • ora-04060 : insufficient privileges to execute string
  • ora-07821 : sspsdn: SYS$DELLNM failure
  • ora-01792 : maximum number of columns in a table or view is 1000
  • ora-24090 : at least one protocol must be enabled
  • ora-02495 : cannot resize file string, tablespace string is read only
  • ora-07263 : sptpa: kill error.
  • ora-25533 : FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified
  • ora-14025 : PARTITION may not be specified for a materialized view or a materialized view log
  • ora-32818 : AQ queue string does not exist
  • ora-00091 : LARGE_POOL_SIZE must be at least string
  • ora-28113 : policy predicate has error
  • ora-01574 : maximum number of concurrent transactions exceeded
  • ora-36666 : (XSDPART04) workspace object is not a concat dimension.
  • ora-08456 : no sign in picture mask but SIGN clause in mask options
  • ora-16734 : error executing dbms_logstdby.skip_error procedure
  • ora-08464 : input raw decimal data contains more than 42 digits
  • ora-34181 : (MXCHGDCL21) workspace object is not a partitioned VARIABLE.
  • ora-14266 : data type or length of an index subpartitioning column may not be changed
  • ora-29831 : operator binding not found
  • ora-36206 : (XSAGOP04R) In AGGMAP workspace object, REMOPERATOR string must be MIN, MAX, FIRST, LAST, HFIRST or HLAST.
  • ora-16597 : Data Guard broker detects two or more primary databases
  • ora-01648 : log string is the current log of disabled instance string (thread string)
  • ora-14062 : one or more of table's partitions reside in a read-only tablespace
  • ora-26663 : error queue for apply process string must be empty
  • ora-15201 : disk string contains a valid RDBMS file
  • 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.