-- Schema import datapump

create or replace directory EXP_DIR as 'F:\Oracle_Backup\datapump\DBSTAR';

-- Import the Data

-- Full
impdp '/ as sysdba' DUMPFILE=EXP_DIR:expdp-odsdv.dmp20170301 LOGFILE=EXP_DIR:odsdvpr_full_impdp.log FULL=Y

-- schemas
impdp '/ as sysdba' DIRECTORY=EXP_DIR DUMPFILE=ITSMPRD_FULL.dpdmp LOGFILE=%ORACLE_SID%_dpimp.log SCHEMAS=QC_USER1,QC_USER2,QC_ADMIN1,QC_ADMIN2,QC_USER3,QC_ADMIN3

-- Tables
impdp '/ as sysdba' tables=DBSTAR.TABLE1 DUMPFILE=DUMP_DIR:DBSTAR_TABLE1.dpdmp LOGFILE=DUMP_DIR:DBSTAR_TABLE1_impdp.log table_exists_action=replace remap_tablespace=DBSTAR_OTHERLOBS:DBSTAR_LOBS