How does the Data Pump generate DDL scripts for Exported Files and export ddl scripts?

Source: Internet
Author: User

How does the Data Pump generate DDL scripts for Exported Files and export ddl scripts?

When using exp/imp, it is very easy to generate the DDL script corresponding to the dumpfile file. When using the command imp, add the show, show = y parameter to display the imp import, output related DDL statements (excluding insert statements) without actually executing them in the database. in fact, the Data Pump (expdp/impdp) can also generate the DDL statement corresponding to the export dumpfile, the parameter is sqlfile. If the sqlfile parameter is added, the SQL DDL script corresponding to the dumpfile is generated, and impdp does not actually execute data import.

SQLFILE Write all the SQL DDL to a specified file.

If you use sqlfile parameter, impdp will not actulally perform the import process, rather it will generate all DDL that are supposed to be executed by impdp in the sqlfile you specified.

You can use a script similar to the following to generate the corresponding SQL DDL script:

Nohup impdp 'userid = "/as sysdba" 'directory = dump_dir full = y dumpfile = full_20160501.dmp logfile = test. log sqlfile = db_ddl. SQL &

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.