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;