Tutorial by Examples

Datapump jobs can be monitored using 1. data dictionary views: select * from dba_datapump_jobs; SELECT * FROM DBA_DATAPUMP_SESSIONS; select username,opname,target_desc,sofar,totalwork,message from V$SESSION_LONGOPS where username = 'bkpadmin'; 2. Datapump status: Note down the j...

create or replace directory DATAPUMP_REMOTE_DIR as '/oracle/scripts/expimp';

Commands: expdp <bkpadmin>/<bkp123> parfile=<exp.par> *Please replace the data in <> with appropriate values as per your environment. You can add/modify parameters as per your requirements. In the above example all the remaining parameters are added in parameter files as...

Prerequisite: Prior to user import it is a good practice to drop the schema or table imported. Commands: impdp <bkpadmin>/<bkp123> parfile=<imp.par> *Please replace the data in <> with appropriate values as per your environment. You can add/modify parameters as per...

Source Server [Export Data]Target Server [Import Data]1. Create a datapump folder that will contain the export dump files4. Create a datapump folder that will contain the import dump files2. Login to database schema that will perform the export.5. Login to database schema that will perform the impor...

expdp <bkpadmin>/<bkp123> directory=DATAPUMP_REMOTE_DIR dumpfile=<customer.dmp> impdp <bkpadmin>/<bkp123> directory=DATAPUMP_REMOTE_DIR dumpfile=<customer.dmp> remap_schema=<source schema>:<target schema> remap_tablespace=<source tablespace&g...