DESCRIPTION:
In this article we are going to see the Oracle 19c Datapump- Sqlfile
Sqlfile option will show you the DDL in the text format.Sometimes customer provides us data pump export file, by that time we will use SQLFILE parameter and find out DDL’s (Schema names) and perform data pump import accordingly.
SYNTAX:
impdp directory=DATA_PUMP_DIR dumpfile=PRODDB_Full.dmp sqlfile=FULL_DDL.sql
[oracle@oracle19c ~]$ impdp directory=My_Dir dumpfile=table01.dmp logfile=table01.log tables='table01' sqlfile=tab.sql
Import: Release 19.0.0.0.0 - Production on Mon Jan 25 09:30:30 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Username: data
Password:
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Master table "DATA"."SYS_SQL_FILE_TABLE_01" successfully loaded/unloaded
Starting "DATA"."SYS_SQL_FILE_TABLE_01": data/******** directory=My_Dir dumpfile=table01.dmp logfile=table01.log tables=table01 sqlfile=tab.sql
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "DATA"."SYS_SQL_FILE_TABLE_01" successfully completed at Mon Jan 25 09:30:36 2021 elapsed 0 00:00:01
[oracle@oracle19c ~]$ cd /u01/app/oracle/oradata/
[oracle@oracle19c oradata]$ ls
compressed1.dmp con01.dmp con.log CONTINUE.dmp My_Dir schema.dmp table01.dmp tablespace.log tabs.log
compressed2.dmp con01.log CONTINUE1.dmp CONTINUE.log ORACLE19C schema.log table01.log tabs00.log tab.sql
compressed.dmp con.dmp CONTINUE1.log export.log ORACLE19CCON tab00.dmp tablespace01.log tabs.dmp
sqlfile activity completed successfully and ‘tab.sql‘ file has created in the specified dump directory location.
[oracle@oracle19c oradata]$ vi tab.sql
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8