ORA-01731
circular view definition encountered
Cause
Through a series of CREATE and DROP VIEW statements, a view was defined that referred to itself. For example, VIEW1 might include a column from VIEW2 that was 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.
ORA-01731
circular view definition encountered
Cause
Through a series of CREATE and DROP VIEW statements, a view was defined that referred to itself. For example, VIEW1 might include a column from VIEW2 that was 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.
ORA-01731
circular view definition encountered
Cause
Through a series of CREATE and DROP VIEW statements, a view was defined that referred to itself. For example, VIEW1 might include a column from VIEW2 that was 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.
