Enable export and import of Oracle data with PL/SQL

I. PL/SQL tools for Oracle data export

1. Data Object Export

Tools, export user objects, pop up the following interface:

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

Note: This method can only export data objects, cannot export data stored in tables,650) this.width=650; "style=" Float:none; "title=" Export user objects. jpg "src="/HTTP/ S3.51cto.com/wyfs02/m02/53/84/wkiom1rpowoqbm20aalgrvxfvws194.jpg "alt=" Wkiom1rpowoqbm20aalgrvxfvws194.jpg "/>

2. Table Data Export

Tools, export table with the following interface:

Method One (Oracle Export mode): Executable file Exp.exe

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

650) this.width=650; "style=" Float:none; "title=" Export table Data 1.gif "src=" http://s3.51cto.com/wyfs02/M02/53/82/ Wkiol1rpodfxv6wdaabbfdpji2a914.gif "alt=" Wkiol1rpodfxv6wdaabbfdpji2a914.gif "/>

Method Two (SQL insert mode) such as:

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

650) this.width=650; "title=" Export 3.gif "src=" http://s3.51cto.com/wyfs02/M00/53/82/ Wkiol1rppjmrobrkaabaavj2bki686.gif "alt=" Wkiol1rppjmrobrkaabaavj2bki686.gif "/>

Ii. PL/SQL tools for Oracle data import

1. Data Object Import

Tools, import table, pop up the following interface:

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

Note: If the namespace and user are inconsistent, you need to manually modify the SQL file.

650) this.width=650; "style=" Float:none; "title=" Import sql.gif "src=" http://s3.51cto.com/wyfs02/M02/53/82/ Wkiol1rpp7bymupjaaahisu8l9g890.gif "alt=" Wkiol1rpp7bymupjaaahisu8l9g890.gif "/>

2. Table Data Import

Tools, import table, pop up the following interface:

Method one (SQL Insert): Select the executable file (sqlplus.exe), select the import file (. sql), then click Import.

650) this.width=650; "style=" Float:none; "title=" Import sql.gif "src=" http://s3.51cto.com/wyfs02/M02/53/82/ Wkiol1rpp7bymupjaaahisu8l9g890.gif "alt=" Wkiol1rpp7bymupjaaahisu8l9g890.gif "/>

Method Two (Oracle Import mode) such as:

the "from user", "to User", respectively, to export the database and import the database user name, select the executable file (Imp.exe),

Select Import file (. dmp) and click Import.

650) this.width=650; "style=" Float:none; "title=" Import dmp.gif "src=" http://s3.51cto.com/wyfs02/M01/53/84/ Wkiom1rpp0lz2d_qaaamukolnaa540.gif "alt=" Wkiom1rpp0lz2d_qaaamukolnaa540.gif "/>

Enable export and import of Oracle data with PL/SQL