PL/SQL Developer Export/import (EXT)

Source: Internet
Author: User
Tags import database

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)

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.