The Library is currently in the process of being upgraded from Oracle Database Version to 18.104.22.168
and version 18.0 is going to be available soon.
Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs,
and other objects you may not be familiar with such as CDB_OBJECTS_AE:
Welcome to 12c and beyond.
Have you viewed the Library's main Table of Contents? If not ... [Click Here]
... scroll down the page and you will find links to the largest collection of Oracle Database demos on the net.
A view is a logical entity: A SQL statement stored in the database in the system tablespace. Data for a view is built in a table created by the database engine in the TEMP tablespace.
ALTER ANY ANALYTIC VIEW
CREATE ANY ATTRIBUTE DIMENSION
DROP ANY ANALYTIC VIEW
ALTER ANY ATTRIBUTE DIMENSION
CREATE ANY HIERARCHY
DROP ANY ATTRIBUTE DIMENSION
ALTER ANY HIERARCHY
CREATE ATTRIBUTE DIMENSION
DROP ANY HIERARCHY
CREATE ANALYTIC VIEW
SELECT ANY TABLE
CREATE ANY ANALYTIC VIEW
Create Analytic View
CREATE OR REPLACE ANALYTIC VIEW <view_name> AS