Original: How to export an Oracle database from a server to a local Oracle database
1. Import the Oracle database on the server to a local
Execute the following command in CMD mode:
Exp Username1/[email protected] Server-side database file= local hard disk:/file name. dmp
For example: Exp admin/[email protected] File=e:db.dmp
2. Establish a local database (the Oracle client is installed by default and a local database is established)
3. Create a new user and give DBA authority
Create a user named Test with password (password) of 123456, the default tablespace is users, and the user is not restricted using the users table space
Create user test identified by 123456
Default Tablespace users
Quota Unlimited on users
Give test user DBA authority
Grant DBA to test;
4. Importing to a local Oracle database
Execute the following command in CMD mode
Imp username2/password file= local hard drive:/file name. DMP fromuser=username1 Touser=username2 Ignore=y
For example: Imp test/123456 file=e:db.dmp fromuser=admin touser=test ignore=y
How to export an Oracle database from the server to a local Oracle database