How to Backup PDB Tablespaceby Ed ChenMarch 17, 2021February 1, 2021Backup 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
How to Resolve ORA-01565: error in identifying fileby Ed ChenJanuary 9, 2021December 9, 2022In 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.by Ed ChenDecember 23, 2020March 16, 2021ORA-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_SIDby Ed ChenDecember 23, 2020February 12, 2023Connect 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 Passwordby Ed ChenDecember 23, 2020June 26, 20236 CommentsExpdp 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