Plsql the correct steps for importing and exporting tables

Plsql the correct steps for importing and exporting tables

Originally always direct tools->import talbes->oracle import results found sometimes error: Some tables can not be imported correctly, Baidu+googel solution is as follows:

Export steps:

1 Tools->export User Object Select option, Export. sql file

2 Tools->export tables-> Oracle Export Selection option exporting. dmp files

Import steps:

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

2 tools->import talbes->oracle Import and then importing the DMP file

The import and export of the database was successful

======================= explanation =====================================================================

Tools->export User Objects exports the build table statements (including the storage structure)

Tools->export tables contains three ways to export:

Three ways can be exported table structure and data, online said three methods are different, 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 also very efficient, most 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 it (prompt below:
table contains one or more LONG columns cannot export in SQL Format,user PL/Developer format instead) can be exported in the first and third ways. 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.

Personally prefer the second method, after all, is the SQL file, I can also see, want to change also convenient

Plsql the correct steps for importing and exporting tables