SLTechnology News&Howtos › Database ›

Export and Import of oracle data with pl/sql

Shulou Source: shulou.com Published: 2022-06-01 09:24:41 10月02日 Update

1. PL/SQL tool to realize oracle data export

1. Data object export

Tools-> Export user objects, and the following interface pops up:

Select the user, select the path to the export file, name the export file name (.sql), and then click Export.

Note: this method can only export data objects, not data stored in the table.

two。 Table data export

Tools-> Export the table and pop up the following interface:

Method 1 (oracle export): executable file exp.exe

Select the path to the export file, name the export file name (.dmp), and then click Export.

Method 2 (SQL insertion mode) is shown below:

Select the path to the export file, name the export file name (.sql), and then click Export.

Second, PL/SQL tools to achieve oracle data import

1. Data object import

Tools-> Import table, the following interface pops up:

Select the SQL insertion method, select the executable file (sqlplus.exe), select the import file (.sql), and then click Import.

Note: if the namespace is inconsistent with the user, you need to modify the sql file manually.

two。 Table data import

Tools-> Import table, the following interface pops up:

Method 1 (SQL insertion method): select the executable file (sqlplus.exe), select the import file (.sql), and then click Import.

Method 2 (Oracle import method) is shown below:

"from user" and "to user" are the user names of the export database and the import database, respectively, and select the executable file (imp.exe)

Select the import file (.dmp) and click Import.