Go Pl/sqldeveloper Import and Export Oracle database method

Source: Internet
Author: User

Original address: http://www.2cto.com/database/201405/305452.html

1.Oracle Database Export Steps

1.1 Tools→export User Objects ... option to export the. sql file.

Note: This step exports the built-in statements (including the storage structure), excluding the data in the table, and the tools→export Tablesis required to export the data.

1.2 Tools→export Tables ... Export table structure and data

The PL/SQL tool contains three ways to export the Oracle table structure and data, three ways are: Oracle export, SQL inserts, pl Developer, respectively, the following is a brief description of the difference:

The first way to export. DMP formatted files,. DMP is a binary file that can be cross-platform and includes permissions that are efficient and widely used.

The second way to export. sql format files, can be viewed with a text editor, versatility is better, 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 way to export. PDE-formatted files,. PDE is PL/SQL Developer's own file format, can only be imported with the PL/SQL Developer tool and cannot be viewed with a text editor.

2. Import Step (tools→import Tables ...)

It is best to delete the previous table before importing the data, except for importing additional database data.

2.1 Oracle Import

Imports an Oracle file of the. DMP type.

2.2 SQL Inserts

Import an Oracle file of type. sql.

2.3 PL/SQL Developer

Import the. PDE type of Oracle file.

The Oracle database is briefly introduced here, and if there is a problem, you can search the PL/SQL Developer operating manual or search for a related issue.

Go Pl/sqldeveloper Import and Export Oracle database method

Related Article

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.