ORA-01731

Error: ORA-01731: circular view definition encountered

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

Acción: Check the view definitions, remove any circular references, and retry the statements.