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-06311: IPA: Maximum number of servers reached

ORA-16757: Resource guard could not get property

DRG-10836: field section and attribute section can not be nested

ORA-16219: This database is not preparing to switch over.

PLS-00416: The third argument of DECODE cannot be NULL

ORA-25307: Enqueue rate too high. Enable flow control

ORA-06704: TLI Driver: receive break message failed

RMAN-06423: requested limit of number exceeds vendor limit of number

ORA-03299: cannot create dictionary table string

ORA-09742: sppst: error during a post.

QSM-01028: materialized view, string, is currently being refreshed

ORA-32628: invalid nesting of MODEL cell reference

For more Oracle Errors Interview Questions Click Here