Oracle Export Import table (. SQL,. dmp file) two methods,. SQL. dmp

Oracle Export Import table (. SQL,. dmp file) two methods,. SQL. dmp

Two ways to export an import table (. SQL and. dmp files) from Oracle

Method 1: Export and Import SQL files

Export procedure

5. Select the table for data export from the list, select SQL insert, select an SQL file, and click Export. This step exports the data to the database.

6. In this way, two SQL statements are used to back up the data structure and data.

Import Procedure

In the plsql tool, click File-new-command window to paste the two. SQL File statements and execute them twice.

 

Method 2: Export and Import dmp files

1. Export the table structure:

Expdp system/admincss @ WSYDBSPT directory = DATA_PUMP_DIR schemas = hx_xt dumpfile = WSYDBS. dmp

Note: system/admincss @ WSYDBSPT administrator username and password, Database Service name, directory = DATA_PUMP_DIR (query by select * from dba_directories), schemas = hx_xt export table structure data from this username

2. Import table structure

Impdp system/admincss @ WSYDBSPT directory = DATA_PUMP_DIR schemas = hx_xt dumpfile = WSYDBS. dmp