sqlfile option with impdp - Oracle Database Script. It can be used, ONLY WITH impdp. This helps IN generating the DDLs FROM a dumpfile. Suppose We have a DUMP FILE OF TABLE AODBA.DEP_TAB . IF you need the DDL OF the TABLE, THEN USE sqlfile WITH impdp command AS below. PARFILE SAMPLE: dumpfile=test.dmp LOGFILE=test1.log directory=TEST TABLES=AODBA.DEP_TAB sqlfile=emp_tab.sql note- DDL OUTPUT will be logged IN the emp_tab.sql FILE
It can be used, ONLY WITH impdp. This helps IN generating the DDLs FROM a dumpfile. Suppose We have a DUMP FILE OF TABLE AODBA.DEP_TAB . IF you need the DDL OF the TABLE, THEN USE sqlfile WITH impdp command AS below. PARFILE SAMPLE: dumpfile=test.dmp LOGFILE=test1.log directory=TEST TABLES=AODBA.DEP_TAB sqlfile=emp_tab.sql note- DDL OUTPUT will be logged IN the emp_tab.sql FILE