Restrictions on Flashback Queries These queries are subject to the following restrictions:

• You cannot specify a subquery in the expression of the AS OF clause.

• You cannot use the VERSIONS clause in flashback queries to temporary or external tables, or tables that are part of a cluster.

• You cannot use the VERSIONS clause in flashback queries to views. However, you can use the VERSIONS syntax in the defining query of a view.

• You cannot specify this clause if you have specified query_name in the query_table_expression.