Plsql Export and Import

Plsql Export and Import

Export Steps:

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

2 tools-> export tables-> Oracle Export select option to export the. dmp File

Import steps:

1 tools-> import tables-> SQL Inserts import. SQL File

2 tools-> import talbes-> Oracle Import and then import the dmp File

The database has been imported and exported.

=================================================== ========================================================== ==================

Tools-> Export User Objects exports table creation statements (including storage structures)

Tools> Export Tables contains three Export methods:

The table structure and data can be exported in any of the following three 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), which can be exported in the first and third ways. The third type is exported to. PVDF format, which is the file format of Pl/SQL developer. You can only import and export files by yourself using Pl/SQL developer. You cannot view the files in the editor.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.