Oracle Import and Export

Import Export

Export a table from a remote database

exp newsoft/[email protected]:1521/taizhouyuant file=d:\\database\\user_table.dmp tables=user_table    

Importing a DMP file into a local library

imp system/[email protected] file=d:\\database\\user_table.dmp full=y ignore=y

If you are operating on a remote database, the format after @ is: 192.168.0.81:1521\taizhouyuant If you are working on a local database, use the instance name directly, such as @orcl

To guide a library from a remote database and put it on its own local end, use the command:

exp newsoft/[email protected]:1521/taizhouyuant file=d:\\database\\user_table.dmp tables=user_table    

But always error, hint chain interface order invalid, check the online data that is remote version of the database and its own local client version of the inconsistency caused, as long as a replacement client can be. I didn't try.
Swap with the Plsql feature for export.

Plsql exported features under Tools, there are three options involved:

1. Export user objects (exports all objects under the users, but only the table structure, no data, exported files are generally used as the suffix of SQL)

2. Export tables, this option is divided into three tabs, as follows:

   A. Oracle Export-exported content can be checked on the page itself, characterized by a DMP file being exported and a binary file B. SQL inserts exports the SQL file

   c. PL/SQL Develop is a form of Plsql's own
   Recommendation: When the data is more than the first, when the data is small with the second

3. Import tables Imports also have three cases, respectively, corresponding to the export of three cases

For exported files, you can also use command import as a reference: [Import Export][1]
[1]:https://www.2cto.com/database/201302/191019.html

Before importing a file, however, we will create a user (with a default tablespace), create a specified tablespace, associate the user to the Tablespace, assign permissions to the user, and then perform the import operation after this step is completed.
Create user, table space, assign permissions reference: [Create User, tablespace, assign permissions][2]
[2]:http://blog.csdn.net/zhengbo0/article/details/17203859

Oracle Import and Export