How to Export a PDB without Passwordby Ed ChenDecember 23, 2020December 18, 2020Export PDB If we want to export data from a Pluggable Database (PDB) using expdp as sysdba by OS Authentication, we will get errors like… Read More »How to Export a PDB without Password
impdp Parameter for All Releases of Oracle Databaseby Ed ChenAugust 5, 2020December 14, 2020Here is the list of impdp available parameters for All Releases of Oracle Database. impdp All Parameters for Oracle Database 21c impdp All Parameters for… Read More »impdp Parameter for All Releases of Oracle Database
expdp Parameter for All Releases of Oracle Databaseby Ed ChenAugust 1, 2020December 14, 2020Here is the list of expdp available parameters for All Releases of Oracle Database. expdp All Parameters for Oracle Database 21c expdp All Parameters for… Read More »expdp Parameter for All Releases of Oracle Database
How to Resolve ORA-39143: dump file may be an original export dump fileby Ed ChenApril 23, 2017August 15, 2018ORA-39143 Was trying to import the data using impdp, but it threw an error ORA-39143. ORA-39143: dump file "/oradata/recovery_area/full.dmp" may be an original export dump… Read More »How to Resolve ORA-39143: dump file may be an original export dump file
How to Duplicate a Schema from One to Anotherby Ed ChenAugust 7, 2016March 29, 2018Suppose you are planning to duplicate user01 schema into user02 schema. Tools like TOAD, SQL Developer can be helpful. But you may also like to… Read More »How to Duplicate a Schema from One to Another
How to expdp AS SYSDBAby Ed ChenMay 13, 2016December 28, 2020expdp AS SYSDBA Normally, we use system to migrate data from one to another, who has pretty enough privileges for all kinds of manipulation at… Read More »How to expdp AS SYSDBA
What Oracle Command-line Utilities Need Authentication - Oracleby Ed ChenJanuary 11, 2013December 24, 2020Oracle provides many utilities to operate the infrastructure and database. Some of them need authentications to access database, but some don't. The bottom line is… Read More »What Oracle Command-line Utilities Need Authentication - Oracle