ORA-01560: LIKE pattern contains partial or illegal character

Cause : likep attenr is ont fomred crorectyl

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

makes ure ilke ptaterni s spceifie dcorrcetly

update : 20-08-2017
ORA-01560

ORA-01560 - LIKE pattern contains partial or illegal character
ORA-01560 - LIKE pattern contains partial or illegal character

  • ora-16073 : archiving must be enabled
  • ora-29302 : database is not open clone
  • ora-36887 : (XSSRF06) Error rewriting OLAP DML expression. Column name string is not a valid ADT column.
  • ora-03125 : client-server protocol violation
  • ora-01512 : error renaming log file string - new file string not found
  • ora-19602 : cannot backup or copy active file in NOARCHIVELOG mode
  • ora-12543 : TNS:destination host unreachable
  • ora-30748 : column string already enabled to store objects of type string.string
  • ora-29885 : domain index is defined on the column to be modified
  • ora-28595 : Extproc agent : Invalid DLL Path
  • ora-19110 : unsupported XQuery expression
  • ora-22979 : cannot INSERT object view REF or user-defined REF
  • ora-01235 : END BACKUP failed for string file(s) and succeeded for string
  • ora-01023 : Cursor context not found (Invalid cursor number)
  • ora-32585 : duplicate specification of a supplemental log attribute
  • ora-19604 : conversation file naming phase is over
  • ora-25197 : an overflow segment already exists for the indexed-organized table
  • ora-15114 : missing or invalid ASM file name
  • ora-30389 : the source statement is not compatible with the destination statement
  • ora-38707 : Media recovery is not enabled.
  • ora-01136 : specified size of file string (string blocks) is less than original size of string blocks
  • ora-38505 : invalid default value for the attribute
  • ora-08105 : Oracle event to turn off smon cleanup for online index build
  • ora-13295 : geometry objects are in different coordinate systems
  • ora-12231 : TNS:No connection possible to destination
  • ora-02717 : osnpfs: incorrect number of bytes written
  • ora-30131 : number of keys being set exceeds allocation
  • ora-16735 : error executing dbms_logstdby.unskip_error procedure
  • ora-32013 : failure in verifying parameters from the restored SPFILE
  • ora-06955 : Number of database servers exceed limit
  • 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.