Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to find seed database files in cdb_data_files

Ankur RainaNov 9 2014 — edited Jan 27 2015

Hi All

I just created a 12c container database using dbca

SQL> select CON_ID, OPEN_MODE, NAME from v$containers;

CON_ID

OPEN_MODE NAME

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

	1 READ WRITE CDB$ROOT
	2 READ ONLY PDB$SEED

But when I use the cdb_data_files view, it shows datafiles from only the CDB$ROOT while changing the session to PDB$SEED, the datafiles are visible in dba_data_files.

My question is why all these are not visible in cdb_data_files view ?

SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 9 16:50:27 2014

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select FILE_NAME from cdb_data_files;

FILE_NAME

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

/u01/app/oracle/oradata/cdb12ct/system01.dbf

/u01/app/oracle/oradata/cdb12ct/sysaux01.dbf

/u01/app/oracle/oradata/cdb12ct/undotbs01.dbf

/u01/app/oracle/oradata/cdb12ct/users01.dbf

SQL> alter session set container=PDB$SEED;

Session altered.

SQL> select FILE_NAME from dba_data_files;

FILE_NAME

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

/u01/app/oracle/oradata/cdb12ct/pdbseed/system01.dbf

/u01/app/oracle/oradata/cdb12ct/pdbseed/sysaux01.dbf

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 24 2015

Added on Nov 9 2014

#database-key-features, #multitenant

14 comments

13,082 views