PL/SQL Developer Export/import (EXT)

Export/import icons are grayed out:
Cause: The associated application is not associated
Menu Bar-- T-ools--Import Tables ...--Oracle Import

Export Executable : %oracle_home%\bin\imp.exe

Output file:c:\documents and settings\administrator\ desktop \eam.dmp

PL/SQL Developer is the primary tool for importing or exporting databases in an Oracle database , and this article mainly describes the process of importing and exporting databases with PL/SQL Developer. Some considerations for importing or exporting are described, and we'll introduce them.

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:

Note: It is better to delete the previous table before importing, except of course the import database.

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,user PL/SQL Developer format instead).

The third is export to. pde format,. PDE is PL/SQL developer own file format, can only be imported and exported by PL/SQL developer, cannot be viewed with editor

Http://blog.sina.com.cn/s/blog_4f925fc30100cyx1.html

Http://www.itpub.net/thread-1794606-1-1.html

http://blog.163.com/shexinyang%40126/blog/static/1367393122013612105445369/

PL/SQL Developer Export/import (EXT)