ORA-12733: regular expression too long

Cause : The operation failed because the regular expression it used exceeds the maximum supported size.

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

Use a shorter regular expression.

update : 27-05-2017
ORA-12733

ORA-12733 - regular expression too long
ORA-12733 - regular expression too long

  • ora-22165 : given index [string] must be in the range of [string] to [string]
  • ora-06260 : NETNTT: cannot write to remote process
  • ora-19261 : XQ0041 - non empty URI in QName
  • ora-29864 : analyzing domain indexes marked LOADING/FAILED not supported
  • ora-26065 : check constraint cannot reference column, string, in direct path load
  • ora-12838 : cannot read/modify an object after modifying it in parallel
  • ora-07240 : slemrd: seek error.
  • ora-06124 : NETTCP: timeout waiting for ORASRV
  • ora-13387 : sdo_batch_size for array inserts should be in the range [number,number]
  • ora-24239 : object could not be invalidated
  • ora-12031 : cannot use primary key columns from materialized view log on "string"."string"
  • ora-15181 : Symbol [string] not found in library string, error [string]
  • ora-12205 : TNS:could not get failed addresses
  • ora-27061 : waiting for async I/Os failed
  • ora-39062 : error creating master process string
  • ora-29971 : Specified table name not found or does not have any registrations
  • ora-27084 : unable to get/set file status flags
  • ora-12502 : TNS:listener received no CONNECT_DATA from client
  • ora-27477 : "string.string" already exists
  • ora-28038 : disallow O2LOGON
  • ora-09847 : soacon: ARCH unable to open named pipe.
  • ora-19675 : file string was modified during proxy copy
  • ora-23478 : object group "string" is already mastered at string
  • ora-31042 : Too many properties in type 'string'
  • ora-24074 : RETRY_DELAY and MAX_RETRIES cannot be used for exception queue %.string
  • ora-36618 : (XSAGMODDIM00) workspace object is not a valid model for AGGMAP ADD.
  • ora-09930 : LUB of two labels is invalid
  • ora-16599 : Data Guard broker detected a stale configuration
  • ora-24816 : Expanded non LONG bind data supplied after actual LONG or LOB column
  • ora-19221 : XP0001 - XQuery static context component string not initialized
  • 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.