DRG-10840: CONTAINS predicate including 0 is not supported
by FIRST_ROWS hint



DRG-10840: CONTAINS predicate including 0 is not supported by FIRST_ROWS hint..

Answer / guest

Cause: User attempts to issue a query with CONTAINS
predicate including 0 while giving FIRST_ROWS hint.

Action: remove FIRST_ROWS hint.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14401: inserted partition key is outside specified partition

1 Answers  


ORA-12206: TNS:received a TNS error during navigation

1 Answers  


KUP-04055: column string is both a field in the data file and a column transform

1 Answers  


TNS-02502: Authentication: unable to find initialization function

1 Answers  


UDE-00015: invalid context or job state for parameter, 'string'.

1 Answers  






ORA-09823: device name is too long

1 Answers  


ORA-02473: Error while evaluating the cluster's hash expression.

1 Answers  


ORA-24167: incompatible rule engine objects, cannot downgrade

1 Answers  


NNL-00342: Log file name is currently string

1 Answers  


ORA-12852: PARALLEL_MIN_SERVERS must be less than PROCESSES, string

1 Answers  


ORA-14028: missing AT or VALUES keyword

1 Answers  


ORA-13853: Tracing for service (module/action) string is already enabled

1 Answers  


Categories