Simple example of using Oracle data pump under NAVICAT

How to use database development tools such as navicat for efficient development will be the focus of future work. Navicat is beautiful enough to operate a fool, and its powerful features are comparable to PL SQL. Today's study is how to use data pump for data import and export in Navicat.

　　

Data pump pre-use matters: to use a data pump must be in a DBA role such as SYS or system

Data export:

1, you must create a table directory before exporting, click "Other"--"directory" to view all the current database directory. Specific example:

　　

Click "New Directory" to create a new directory, the directory path must be real. Once you have completed the path, click Save. Specific example:

　　

Then click "Data Pump"-"data pump export" into the data pump export interface;

Next select the mode, according to the pattern (full--all export, tablespace--table space, schema--user node under the Object collection, table--table) can export data according to relevant indicators;

The implementation of this article is in the user unit, in the export data below the blank box to select the user object that needs to be exported, this example needs to export the user is arrears;

Next, in the dump file, select the directory and the file name that you saved, and then click Generate SQL.

　　

SQL Preview can be seen in the concrete generated SQL, confirm that the SQL is not a problem, click to run (due to the limited database level, I do not see whether there are errors ....) Ashamed of ...)

　　

After clicking Run, you can see the following running process:

　　

When you see that the data export is complete after successful completion, you can see the exported DMP file in the corresponding directory:

　　

The Data export section is complete.

　　

　Data import:

　　　　Data export after the data can be imported, say no more to continue:

Click on "Data Pump"--"Data pump import"

　　

Subsequent selection mode is "schema" (User node collection)

Then select "The action of the table exists", that is, if the imported user under the table name of the same table data pump selected operation, there is a total of "skip"-Skip, "APPEND"-Append, "TRUNCATE"-Empty table, "replace"--replace four operations,

Next, enter the name of the user node that you want to import data into in the input box of the pattern, this example is arrears,

Then select the directory and file name of the dump file (oddly enough, the previously exported arrears.dmp file name becomes ARREARS.DMP.DMP in the optional list, but fortunately can be modified, directly modified to the actual file name)

　　

After clicking Generate SQL, check for any exceptions to SQL:

　　

Click to run, see the XXXX time to run a successful description of the import is complete!

　　

Check the table under the arrears user, it's all in.

　　

Simple example of using Oracle data pump under NAVICAT