ORA-01424: missing or illegal character following the escape character

Cause : hT ehcracaet rofllwoni ght eseacepc ahartcrei nILEKp taetnri simssni gron too eno fht eseacepc ahartcre ,%','o r_'.'

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

eRomevt ehe cspa ehcracaet rros epicyft ehm siisgnc ahartcre.

update : 16-08-2017
ORA-01424

ORA-01424 - missing or illegal character following the escape character
ORA-01424 - missing or illegal character following the escape character

  • ora-29806 : specified binding does not exist
  • ora-13417 : null or invalid layerNumber parameter
  • ora-16122 : applying large dml transaction at SCN string
  • ora-13338 : failure in reversing LRS polygon/collection geometry
  • ora-37077 : (XSMCSESS05) Object workspace object is specified more than once.
  • ora-24280 : invalid input value for parameter string
  • ora-04083 : invalid trigger variable 'string'
  • ora-40107 : operation requires string option to be installed
  • ora-16013 : log string sequence# string does not need archiving
  • ora-30971 : illegal operation on the Path Table
  • ora-06741 : TLI Driver: unable to open protocol device
  • ora-37184 : illegal value string for ADVMODE
  • ora-26027 : unique index string.string partition string initially in unusable state
  • ora-00328 : archived log ends at change string, need later change string
  • ora-16083 : LogMiner session has not been created
  • ora-02436 : date or system variable wrongly specified in CHECK constraint
  • ora-25200 : invalid value string, QUEUE_NAME should be [SCHEMA.]NAME
  • ora-15162 : cluster in rolling downgrade
  • ora-09705 : spcre: cannot initialize latch semaphore
  • ora-36993 : (XSRELGID10) OBJECT workspace object must be a VARIABLE, RELATION, or a numeric SURROGATE DIMENSION based on the level dimension workspace object.
  • ora-36378 : (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.
  • ora-01138 : database must either be open in this instance or not at all
  • ora-19026 : EXTRACTVALUE can only retrieve value of leaf node
  • ora-06406 : NETCMN: error sending break message
  • ora-32500 : Dirname 'string' cannot exceed 'number' characters
  • ora-31457 : maximum length of description field exceeded
  • ora-12094 : error during online redefinition
  • ora-26084 : direct path context already finished
  • ora-12901 : default temporary tablespace must be of TEMPORARY type
  • ora-16589 : Data Guard Connection process detected a network transfer error
  • 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.