Hi,
Question 1:
Please advise on the Use of SQLFILE and CONTENT=METADATA_ONLY together in Datapump import ( impdp).
If SQLFILE is used, will it ignore even if we specify CONTENT=METADATA_ONLY along with it?
Is SQLFILE alone enough for exporting only definitions from export dump?
impdp DWH_DBA/XXXXXXX@ DBNAME DUMPFILE=DW1_expdp_backup_%U.dmp LOGFILE=DATA_PUMP_DIR:IMP_DDL.log REMAP_SCHEMA=S_CPO:T_CPO TABLES=S_CPO.TEST_TAB PARFILE=imp_parfile.txt SQLFILE=IMP_DDL.sql
impdp DWH_DBA/XXXXXXX@ DBNAME DUMPFILE=DW1_expdp_backup_%U.dmp LOGFILE=DATA_PUMP_DIR:IMP_DDL.log REMAP_SCHEMA=S_CPO:T_CPO TABLES=S_CPO.TEST_TAB PARFILE=imp_parfile.txt SQLFILE=IMP_DDL.sql CONTENT=METADATA_ONLY
Content of PARFILE=imp_parfile.txt
JOB_NAME=IMP_DBNAME_T_CPO
LOGTIME=ALL
PARALLEL=8
REMAP_TABLESPACE=HIST_DATA:C_DATA,HIST_IDX:C_IDX
TRANSFORM=OID:N
Question 2:
Importing a Single table from full db exported dump files.
Using SCHEMAS and INCLUDE Params Vs TABLES PARAM
Is there any difference( advantages) in using
SCHEMAS=S_CPO
INCLUDE=TABLE:"IN ('H_RULE')"
instead of
TABLES=S_CPO.H_RULE
Regards,
Veera V