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-36726: (XSALERR00) The character 'character' is not a valid format specifier for the ALLOCATE error log.

1 Answers  


ORA-02220: invalid MINEXTENTS storage option value

1 Answers  


RMAN-06030: the DELETE [ALL] INPUT option may not be used with a datafile backup set

1 Answers  


ORA-16608: one or more sites have warnings

2 Answers  


TNS-00065: INTCTL: Command cannot be executed remotely

1 Answers  






NNL-00559: Shows, sets, or cancels the time for the next cache dump to the trace file

1 Answers  


LPX-00283: document encoding is ~s-based but default input encoding is not

1 Answers  


NNL-00542: restart [<server_list>] : restart one or more Names servers

1 Answers  


ORA-32766: instr with negative offset: use varchar semantics on LOBs

1 Answers  


ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)

1 Answers  


ORA-06927: CMX: T_DATAIN received before all data written

1 Answers  


PLS-01506: CREATE INDEX is non-ANSI

1 Answers  


Categories