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-16180: number processes specified for MAX_PARALLEL_SERVERS is too small

ORA-39102: Timeout before master process string finished initialization. Master error:

ORA-27198: skgfpvl: sbtpcvalidate returned error

ORA-29665: Java thread deadlock detected

QSM-00769: the SQL statement string was not found for workload string

ORA-22916: cannot do an exact FETCH on a query with Nested cursors

SQL*Loader-00502: unable to open data file 'string' for field string table string

ORA-02427: create view failed

ORA-19734: wrong creation SCN - control file expects converted plugged-in datafile

ORA-24323: value not allowed

ORA-22993: specified input amount is greater than actual source amount

ORA-14612: Duplicate lob segment name string for lob column string in template

For more Oracle Errors Interview Questions Click Here