PL/SQL Developper Import and Export database method and description

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