📋Steps in this guide1/1

sqlfile option with impdp

It can be used, only with impdp. This helps in generating the DDLs from a dumpfile. Suppose We have a dump file of table DBACLASS.DEP_TAB . If you need the DDL of the table, then use sqlfile with impdp command as below.

oracle configurationintermediate

by OracleDba

14 views

sqlfile option with impdp

PARFILE SAMPLE:

Code/Command (click line numbers to comment):

It can be used, only with impdp. This helps in generating the DDLs from a dumpfile.
Suppose We have a dump file of table DBACLASS.DEP_TAB . If you need the DDL of the table, then use sqlfile with impdp command as below.
dumpfile=test.dmp
logfile=test1.log
directory=TEST
tables=DBACLASS.DEP_TAB
sqlfile=emp_tab.sql
note- DDL output will be logged in the emp_tab.sql file

Comments (0)

Please to add comments

No comments yet. Be the first to comment!