PL/SQL Developer import and export Oracle database method

The previous blog describes the method of backing up Oracle with the Navicat tool, which describes how to import and export an Oracle database using the PL/SQL developer tool.

PL/SQL Developer is one of the primary tools used by Oracle databases to import and export databases, and this article focuses on the process of exporting an Oracle database with PL/SQL import.

1.Oracle Database export steps

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

Description: This step exports the build Table statement (including the storage structure).

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.

PL/SQL Developer tool Import and export Oracle database simply introduced here, if there is a problem, you can search the PL/SQL Developer operation manual, you can also search and solve related issues.