Importing local DMP files to a remote Orcale database, locally in a orcale-free environment

The local server does not have the Orcale database and client installed, and Plsql is not installed. Therefore the imp command of CMD cannot be used.

1. Install the Orcale client locally, install, configure path, and then import the DMP file with the IMP command after installation.

2. Install Instantclient_11_2, and unzip OK;

3. Install Plsql,, unzip the direct punch card Plsqldev.exe, the interface is English, can be changed to Chinese. Configure the Orcale path and OCI path.

4. Import the DMP file using the Import table feature in Plsql.

5. As for how to connect remote data, Baidu has a lot.

   
   

6. 650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M01/95/61/wKiom1kUZ8DjzuLnAAD2yvUJM0o305.png-wh_500x0-wm_ 3-wmp_4-s_1756868081.png "style=" Float:none; "title=" 1.png "alt=" Wkiom1kuz8djzulnaad2yvujm0o305.png-wh_50 "/>

7. 650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M02/95/60/wKioL1kUZ8HBxtNbAAECdNHLy2M009.png-wh_500x0-wm_ 3-wmp_4-s_2767816713.png "style=" Float:none; "title=" 2.png "alt=" Wkiol1kuz8hbxtnbaaecdnhly2m009.png-wh_50 "/>

This article is from the "end of the shame" blog, please be sure to keep this source http://puregirl.blog.51cto.com/12887727/1953881

Importing local DMP files to a remote Orcale database, locally in a orcale-free environment