Description:-
- In this article we are going to see the Oracle 18c Datapump- SQLFILE
- This parameter is used in impdp operation.It will create sqlfile with DDL that could be executed in another database/schema to create the tables and indexes.
- Datapump import does not perform an import of the contents of the dump file. Rather, the sqlfile parameter create a script that contains all DDL from within the export dump file.
[oracle@test18c ~]$ impdp hari/oracle DIRECTORY=TESTDIR DUMPFILE=hari.dmp LOGFILE=hari.log sqlfile=hari_dbfull.sql Import: Release 18.0.0.0.0 - Production on Fri Aug 24 13:52:01 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Master table "HARI"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded Starting "HARI"."SYS_SQL_FILE_FULL_01": hari/******** DIRECTORY=TESTDIR DUMPFILE=hari.dmp LOGFILE=hari.log sqlfile=hari_dbfull.sql Processing object type DATABASE_EXPORT/SCHEMA/USER Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS Processing object type DATABASE_EXPORT/STATISTICS/MARKER Job "HARI"."SYS_SQL_FILE_FULL_01" successfully completed at Fri Aug 24 13:52:06 2018 elapsed 0 00:00:04
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba