Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The PDB$SEED or SEED database is a pluggable database template for pluggable databases to be created by users. Used as a template to create new pluggable databases.
The PDB$SEED database’s container id is always 2. You can get information about PDB$SEED from v$pdbs. You need to be in the root container after connecting to the database. Otherwise, you cannot see the PDB$SEED database.
1 2 3 4 5 6 7 8 9 10 | SQL> alter session set container = CDB$ROOT; Session altered. SQL> select dbid, con_id, name from v$pdbs; DBID CON_ID NAME ---------- ---------- ------------------------------ 5066976788 2 PDB$SEED 5186738667 3 ORCL |
We can set the current container as PDB$SEED as follows.
1 2 3 4 5 6 7 8 9 | SQL> ALTER SESSION SET CONTAINER = PDB$SEED; Session altered. SQL> show con_name CON_NAME ------------------------------ PDB$SEED |
