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 before 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 to. sql files, available text Editor view, versatility is better, but less efficient than the first, suitable for small data import and export, especially note that the table can not have a large number of fields (Blob,clob,long), if there is, you will not be prompted to export (prompted as follows:
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.
Transferred from: http://www.cnblogs.com/kunpengit/archive/2012/11/07/2758710.html
Plsql the correct steps for importing and exporting tables