Oracle 12c Container views - CDB_ Views
Today, I did get an opportunity to research on Containers and pluggable databases - the "single instance, multiple databases" concept that's one of the new features of Oracle 12c. I was really curious to know where the container view data comes from, in other words, where does the data for the CDB_ views come from? Well, this is what I found: It is actually coming from a function: SQL> select name,user,cdb from v$database; NAME USER CDB --------- ------------------------------ --- MY12CDB SYS YES 1 row selected. SQL> select dbms_metadata.get_ddl ('VIEW','CDB_OBJECTS') from dual; DBMS_METADATA.GET_DDL('VIEW','CDB_OBJECTS') -------------------------------------------------------------------------------- CREATE OR REPLACE FORCE NONEDITIONABLE VIEW "SYS"."CDB_OB JECTS" CONTAINER_DATA ("OWNER", "OBJECT_NAME", "SUBO