VIEW statement to drop an analytic view. An
VIEW object is a component of analytic views.
To drop an analytic view in your own schema, you must have the
VIEW system privilege. To drop an analytic view in another user's schema, you must have the
VIEW system privilege.
Specify the schema in which the analytic view exists. If you do not specify a schema, then Oracle Database looks for the analytic view in your own schema.
Specify the name of the analytic view to drop.
The following statement drops the specified analytic view object:
DROP ANALYTIC VIEW sales_av;