How to Backup PDB Tablespace
Backup Tablespace Normally Since tablespace is a logical set of data files, it's allowable to have same name tablespaces in different pluggable databases (PDB). Therefore,… Read More »How to Backup PDB Tablespace
ORACLE_PDB_SID
How to Resolve ORA-01565: error in identifying file
In this post, I'll describe two error patterns for ORA-01565. Missing SPFILE Multitenant DB A. ORA-01565 for Missing SPFILE To create a plain-text parameter file,… Read More »How to Resolve ORA-01565: error in identifying file
How to Resolve ORA-39195: At least one schema in the TABLE_FILTER does not exist.
ORA-39195 ORA-39195 means that tables that you want to export does not exist in the current database, even though you qualify exported tables by schema… Read More »How to Resolve ORA-39195: At least one schema in the TABLE_FILTER does not exist.
Connect to PDB as SYSDBA by ORACLE_PDB_SID
Connect as SYSDBA We usually connect to the database by / as SYSDBA without providing any password for maintenance works, such as startup, shutdown and… Read More »Connect to PDB as SYSDBA by ORACLE_PDB_SID
How to expdp PDB as SYSDBA without Password
Expdp PDB as SYSDBA If we want to export data from a Pluggable Database (PDB) using expdp as sysdba by OS Authentication, we will get… Read More »How to expdp PDB as SYSDBA without Password