How to export an Oracle database from a server to a local Oracle Database: oracle Database

How to export an Oracle database from a server to a local Oracle Database: oracle Database

1. Import the Oracle database on the server to the local

Run the following command in CMD mode:

Exp username1/password @ Server database file = Local Hard Disk:/file name. dmp

Example: exp admin/123123 @ DB file = e:/db. dmp

2. Create a local database (the Oracle client is installed by default and the local database is created

Omitted

3. Create a new user and grant the DBA permission

// Create a user named test with a password of 123456. The default tablespace is users, and the user's users tablespace is unrestricted.

Create user test identified by 123456

Default tablespace users

Quota unlimited on users;

// Grant the DBA permission to the test user

Grant dba to test;

4. import data to the local Oracle Database

Run the following command in CMD mode:

Imp username2/password file = Local Hard Disk:/file name. dmp fromuser = username1 touser = username2 ignore = y

For example: imp test/123456 file = e:/db. dmp fromuser = admin touser = test ignore = y

Remote oracle Database Export local

Exp Sort me/server@192.168.8.1: 1521/race file = d: \ race. dmp full = y

How can I export a remote oracle database to a local computer?

First, you can access the remote database.

Exp username/password @ oracleservername
The exported address is displayed. Enter the address file.

First, if you want to use the cmd command locally, you must have oracle installed on your computer. Otherwise, you cannot export data.