How to expdp AS SYSDBA without Password
expdp 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 without Password
Data Pump
How to Change the Owner of Tables
The following statement is wrong if you are trying to change the owner of a table via rename clause:SQL> alter table hr.employees rename to sh.employees;alter… Read More »How to Change the Owner of Tables
How to Self-Import by Data Pump in Network Mode
If you would like to copy tables from one schema to another, the first idea could be Create Table As Select (CTAS), but CTAS is… Read More »How to Self-Import by Data Pump in Network Mode
How to Use Data Pump Network Mode
Data pump has a very nice feature since 10g, which can make data imported directly from source to target via network connection without any intermediate… Read More »How to Use Data Pump Network Mode
How to Export a Table With Selected Columns
If you want to migrate only a part of a specific table, there are two possible goals that you may want to achieve:To migrate a… Read More »How to Export a Table With Selected Columns
What Oracle Command-line Utilities Need Authentication - Oracle
Oracle 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
How to Enter Interactive Mode While a Data Pump Job is Running
Data pump has very neat feature called interactive-command mode, DBA can change the status or content of the export/import job while it is running. The… Read More »How to Enter Interactive Mode While a Data Pump Job is Running
How to Make Data Pump Faster
Data Pump is a more flexible and powerful utility than legacy exp or imp, which has no NLS_LANG conversion issue bothering us, so we like… Read More »How to Make Data Pump Faster