Search notes:

Oracle: Init parameter _EXCLUDE_SEED_CDB_VIEW

If _exclude_seed_cdb_view is set to true (which is the default), everything releated to PDB$SEED is hidden in queries related to multitenant containers.

Example

When connected to a container root, the data files for pdb$seed are not shown in using the following query:
select *
from
   cdb_data_files;
However, when setting _exclude_seed_cdb_view to false, the pdb$seed data files are included in the previous query:
alter session set "_exclude_seed_cdb_view" = true;
It's probably good practice to revert this change after having seen the relevant information:
alter session set "_exclude_seed_cdb_view" = false;
It's also possible to view the data files of pdb$seed by setting the current container to pdb$seed.
alter session set container = pdb$seed;
However, only this container's data files are now shown in cdb_data_files.
Going back to the original container:
alter session set container = cdb$root;

See also

Mike Dietrich: Why is EXCLUDE_SEED_CDB_VIEW now _EXCLUDE_SEED_CDB_VIEW in Oracle 12.2?

Index