ORA-01560: LIKE pattern contains partial or illegal character

Question Posted / guest

Answers were Sorted based on User's Feedback

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

Answer / guest

Cause: like pattern is not formed correctly

Action: make sure like pattern is specified correctly

Please add more information about this Error

Is This Answer Correct ?

1 Yes

0 No

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

Answer / abhishek dubey

It occurs because lack of tablespace, so increase the size of the tablespace.

Is This Answer Correct ?

0 Yes

0 No

More Oracle Errors Interview Questions

ORA-01226: file header of log member is inconsistent with other members

DRG-11867: Method Not Suited For Automatic Redirection

ORA-29336: Internal error [string] [string] from DBMS_PLUGTS

RMAN-06171: not connected to target database

ORA-19664: file type: string, file name: string

ORA-29835: ODCIGETINTERFACES routine does not return required interface(s)

ORA-19556: required destination LOG_ARCHIVE_DUPLEX_DEST currently is deferred

ORA-29911: null scan context returned by ODCIIndexStart() routine

ORA-08103: object no longer exists

PLS-00162: Pragma string expects 4th argument to be a positive integer literal

ORA-10563: Test recovery had to corrupt data block (file# string, block# string) in order to proceed

ORA-31689: illegal value for base worker id, string

For more Oracle Errors Interview Questions Click Here