How to export an Oracle database from the server to a local Oracle database

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.