Analyzing the method and explanation of PL and SQL Developer importing and exporting database

PL/SQL Developer is the main tool for importing or exporting database in Oracle database. This paper mainly introduces the process of importing and exporting database by PL/SQL Developer, and explains some matters needing attention when importing or exporting. Next, we will introduce 11.

Export step:
1 tools - > export user object Select the option to export the. sql file.
2 tools - > export tables- > Oracle Export Select the option to export the. dmp file.
Import steps:
Note: It is best to delete the previous tables before importing, 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.
1 Some instructions:
Tools- > Export User Objects exports table building statements (including storage structures).
Tools- > Export Tables contains three export methods, all of which can export table structure and data, as follows:
•Oracle Export
•Sql Insert
•pl/sql developer

The first is exported to. dmp file format. dmp file is binary, can cross-platform, but also can contain permissions, efficiency is also very good, the most widely used.
The second is exported to. sql file, available text editor view, versatility is better, but the efficiency is not as good as the first, suitable for small data import and export. Note in particular that the table cannot have large fields (blob, clob, long). If it does, it will be prompted that it cannot be exported (the prompts are as follows: table contains one or cannot columns cannot export in sql format, user developer format instead).
The third type is exported to. pde format, and. pde is Pl/sql developer's own file format, which can only be imported and exported by Pl/sql developer itself, and cannot be viewed by editor.