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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758199020, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/adminstration/init-parameters/exclude_seed_cdb_view(63): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78