PL/SQL developer Import and Export Database methods and instructions

PL/SQL developerYesOracle DatabaseThis document describes how to use PL/SQL developer to import and export databases, and describes precautions for importing or exporting databases, next we will introduce them one by one.

Export Steps:

1 tools-> Export user object selection option to export the. SQL file.

2 tools-> export tables-> Oracle export select to export the. dmp file.

Import steps:

Note: It is best to delete the previous tables before import, except for importing other databases.

1 tools-> Import tables-> SQL inserts import. SQL file.

2 tools-> Import talbes-> Oracle import and then import the DMP file.

Notes:

Tools-> Export user objects exports table creation statements (including storage structures ).

Tools-> export tables contains three export methods:

• Oracle Export
• SQL insert
• PL/SQL developer

The first is the file format exported as. dmp. The. dmp file is binary and can be cross-platform and contain permissions, which is very efficient and widely used.

The second type is exported as a. SQL file, which can be viewed in a text editor and has good versatility, but is not as efficient as the first type. It is suitable for importing and exporting small data volumes. Note that there cannot be large fields (blob, clob, long) in the table. If so, the system will prompt that the data cannot be exported (the prompt is as follows: table contains one or more Long Columns cannot export in SQL format, user PL/SQL developer format instead ).

The third type is exported to. PVDF, which is the file format of PL/SQL developer. Only PL/SQL developer can import and export files by themselves, and cannot be viewed in the editor.

This article describes how to use PL/SQL developer to import and export Oracle databases. I hope this article will bring you some benefits. Thank you for your consideration.