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

NNL-00963: Timeouts, name TTL expired: number

1 Answers  


ORA-14292: Partitioning type of table must match subpartitioning type of composite partition

1 Answers  


NNO-00607: server will forward to default forwarders only

1 Answers  


PCB-00553: FOR clause not allowed on this statement

1 Answers  


ORA-27052: unable to flush file data

1 Answers   Aomi,






TNS-12543: TNS:destination host unreachable

1 Answers  


ORA-25197: an overflow segment already exists for the indexed-organized table

1 Answers  


ORA-02234: changes to this table are already logged

1 Answers  


ORA-04097: DDL conflict while trying to drop or alter a trigger

1 Answers  


ORA-30508: client logon triggers cannot have BEFORE type

1 Answers  


ORA-22601: pickler TDS context [string] is not initialized

1 Answers  


RMAN-06032: at least 1 channel of TYPE DISK must be allocated to execute a COPY command

1 Answers  


Categories