Tag Archives: ORA-01731

ORA-01731: circular view definition encountered

oracle

ORA-01731: circular view definition encountered
Cause: Through a series of CREATE and DROP VIEW statements, a view was defined that refers to itself. For example, VIEW1 might include a column from VIEW2 that is defined as a column in VIEW1. View definitions may be seen by querying the data dictionary.
Action: Check the view definitions, remove any circular references, and retry the statements.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/