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

DRG-10307: no servers running

1 Answers  


NNL-00009: encryption of server password failed

1 Answers  


ORA-01409: NOSORT option may not be used; rows are not in ascending order

1 Answers  


LPX-00405: unable to allocate memory

1 Answers  


DRG-11849: Heuristic Expiration

1 Answers  






ORA-02199: missing DATAFILE/TEMPFILE clause

1 Answers  


ORA-07623: smscre: $CRMPSC failure

1 Answers  


QSM-02124: object type in WHERE clause

1 Answers  


PROT-00008: Failed to import data from specified file to the cluster registry

1 Answers  


ORA-40262: NMF: number of features not between [1, string]

1 Answers  


KUP-00550: parser package failed to load

1 Answers  


ORA-39109: Unprivileged users may not operate upon other users' schemas

1 Answers  


Categories