[Export Import of Pl/sql]oracle database

A. PL/SQL Developer tools generally import and export to Oracle in the following 4 ways: 1, Oracle Export Import method

In this way, export the file format that is imported as. DMP, which is binary, can be cross-platform, can also contain permissions, is efficient, and uses the widest range. In addition, the table structure and index structure did not change after the import was exported, and the other 2 methods changed the index type.

2. SQL Insert Method

This way export import into. sql file format, can be viewed with a text editor, versatility is better, but less efficient than the first, suitable for small data import export. It is especially important to note that there are no large fields (BLOB, CLOB, long) in the table.

3, PL/SQL developer mode

In this way export is imported into. PDE format, the. PDE is PL/SQL Developer's own file format, can only be imported and exported by PL/SQL developer. Pde files cannot be viewed with the editor and are less versatile.

4. Excel mode

Importing in this way is exported to Excel format, Excel format Import is cumbersome, and is not suitable for big data export import. The format file itself can be edited.

[Export Import of Pl/sql]oracle database