Oracle Data Dictionary
Oracle Data Dictionary is the metadata about database and database objects.
Oracle data dictionary views, owned by SYS user, will start with any one of 3 character strings i.e. starts with DBA_ or ALL_ or USER_ or CDB_
CDB_ views --> All information and objects in the CDB across all PDBs. These will be accessible by users having DBA privileges. To query at CDB level, you must be in root container, otherwise it'll display records at PDB level.
CDB_ views --> All information and objects in the CDB across all PDBs. These will be accessible by users having DBA privileges. To query at CDB level, you must be in root container, otherwise it'll display records at PDB level.
DBA_ views --> All information and objects in a container or PDB. These will be accessible by users having DBA privileges.
ALL_ views --> All information and objects accessible by a user.
USER_ views --> All information and objects owned by a user.
e.g: CDB_SYNONYMS, DBA_SYNONYMS, ALL_SYNONYMS, USER_SYNONYMS
ALL_ views --> All information and objects accessible by a user.
USER_ views --> All information and objects owned by a user.
e.g: CDB_SYNONYMS, DBA_SYNONYMS, ALL_SYNONYMS, USER_SYNONYMS
No comments:
Post a Comment