Oracle | CDBVIEW

Oracle CDBVIEW Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Creates CDB views for all DBA views. Source code is all clear-text.

AUTHID CURRENT_USER

Dependencies

CDBVIEW_INTERNAL	DBMS_STANDARD	GETLONG
DBMS_APP_CONT_ADMIN

Documented No

First Available 12.1

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role

Source {ORACLE_HOME}/rdbms/admin/catcdbviews.sql

Subprograms

CREATE_CDBVIEW

GETLONG

CREATE_CDBVIEW

Creates, or recreates, the CDB Views cdbview.create_cdbview( chk_upgrd IN BOOLEAN, owner IN VARCHAR2, oldview_name IN VARCHAR2, newview_name IN VARCHAR2); True indicates the call is part of an upgrade and the views are not recreated. False indicates the call is not part of an upgrade and all CDB views are (re)created.

-- the following 
      example from $ORACLE_HOME/rdbms/admin/cdsec.sql (formatted for clarity)

      

      execute cdbview.create_cdbview(FALSE,'SYS','DBA_PROXIES','CDB_PROXIES');

GETLONG

opcode = 1 accesses view$
opcode = 2 accesses cdef$ cdbview.getlong( opcode IN NUMBER, p_rowid IN ROWID) RETURN VARCHAR2;

SELECT sys.cdbview.getlong(1,'AAAABfAABAAAARhAAC');

      

      SYS.CDBVIEW.GETLONG(1,'AAAABFAABAAAARHAAC')

      --------------------------------------------------------------------------------------

      select "LIB_IDX","LIB_NAME","VENDOR_NAME","PROTOCOL_NUM","VERSION_NUM","PATH_NAME", 
      "MAP_FILE","FILE_CFGID","MAP_ELEM","ELEM_CFGID","MAP_SYNC","CON_ID" from 
      v$map_library