ORA-30930: NOCYCLE keyword is required with
CONNECT_BY_ISCYCLE pseudocolumn



ORA-30930: NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudocolumn..

Answer / guest

Cause: CONNECT_BY_ISCYCLE was specifed in a query which does
not have the NOCYCLE keyword.

Action: Remove CONNECT_BY_ISCYCLE or add NOCYCLE.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16128: User initiated shut down successfully completed

1 Answers  


ORA-36692: (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [inhierarchy {variable | valueset}].

1 Answers  


ORA-23402: refresh was aborted because of conflicts caused by deferred txns

1 Answers  


PLS-00605: set operators are not yet supported as an argument to a MULTISET operator

1 Answers  


ORA-25232: duplicate recipients specified for message

1 Answers  


TNS-01081: Started with pid=string

1 Answers  


SQL*Loader-00423: element count is greater than maximum allowed for the column

1 Answers  


ORA-27026: skgfrls: sbtend returned error

1 Answers  


RMAN-08105: channel string: backup cancelled because no pieces were found

1 Answers  


DRG-11834: Unsupported Media Type

1 Answers  


ORA-07493: scgrcl: lock manager error.

1 Answers  


ORA-22971: invalid datatype for PRIMARY KEY-based object identifier

1 Answers  


Categories