PL/SQL Developper Import and Export database method and description

Source: Internet
Author: User

Export steps

1 Tools->export User Object Select option to export the. sql file.

2 Tools->export tables-> Oracle Export Select option exports. dmp files.

Import steps

1 tools->import tables->sql inserts import. SQL file.

2 tools->import talbes->oracle Import before importing the DMP file.

Some notes

Tools->export User Objects exports the build table statements (including the storage structure).
Tools->export tables contains three kinds of export methods, three ways to export table structure and data, as follows:

? Oracle Export
? SQL Insert
? PL/SQL Developer

  The first is the file format exported to. DMP, which is binary, can be cross-platform, can also contain permissions, and is very efficient and widely used.
The second is exported as. sql files, can be viewed with a text editor, versatility is better, but less efficient than the first, suitable for small data import and export. In particular, it is important to note that there are no large fields (Blob,clob,long) in the table, and if so, you will not be able to export (prompt for the following: table contains one or more long columns cannot export in SQL Format,use R PL/SQL developer format instead).
The third is exported to. Pde format, the. PDE is PL/SQL Developer's own file format, can only be imported and exported by PL/SQL developer, and cannot be viewed with the editor.

PL/SQL Developper Import and Export database method and description

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.