expdp/impdp commands

create or replace directory data_pump_dir as '/flashblade_backup/exports/lab19c_bkps';

expdp DIRECTORY=data_pump_dir DUMPFILE=expdp_19clabdb_full_%U.dmp  logfile=expdp_19clabdb_full.log FULL=Y  parallel=4

expdp DIRECTORY=data_pump_dir DUMPFILE=expdp_19clabdb_schema_test1.dmp  logfile=expdp_19clabdb_schema_test1.log SCHEMAS=TEST1

expdp DIRECTORY=data_pump_dir DUMPFILE=expdp_19clabdb_table_test1_emp1.dmp  logfile=expdp_19clabdb_table_test1_emp1.log TABLES=TEST1.EMP1

expdp DIRECTORY=data_pump_dir DUMPFILE=expdp_19clabdb_full_exclude_%U.dmp  logfile=expdp_19clabdb_full_exclude.log FULL=Y  parallel=4 EXCLUDE=SCHEMA:"IN('TEST1')"

impdp DIRECTORY=data_pump_dir DUMPFILE=expdp_19clabdb_schema_test1.dmp logfile=impdp_test1_lab1.log tables=TEST1.TAB1

impdp DIRECTORY=data_pump_dir DUMPFILE=expdp_19clabdb_schema_test1.dmp logfile=impdp_test1_lab1.log SCHEMAS=TEST1  REMAP_SCHEMA=TEST1:MEGHANA

impdp DIRECTORY=data_pump_dir DUMPFILE=expdp_19clabdb_schema_test1.dmp logfile=impdp_test1_lab1.log tables=TEST1.TAB1  REMAP_TABLE=TAB1:TAB2

impdp DIRECTORY=data_pump_dir DUMPFILE=expdp_19clabdb_schema_test1.dmp logfile=impdp_test1_lab1_meta.log tables=TEST1.TAB1 content=metadata_only

impdp DIRECTORY=data_pump_dir DUMPFILE=expdp_19clabdb_schema_test1.dmp logfile=impdp_test1_lab1_data.log tables=TEST1.TAB1 content=data_only