|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.