Oracle Database Export and Import

Source: Internet
Author: User
Tags import database

Oracle Database Export and Import

You need to export data from Oracle Database A as A *. dmp file, and then import the *. dmp file to database B.

1. Export Database

Enter the following command in the cmd window:

Export all databases

Exp username/password @ database name file = d: \ *. dmp full = y

Export the database of the current user

Exp username/password @ database name owner = (username) file = d: \ *. dmp

2. Connect to database B

Run the following command under SQL plus:

Conn sys/sys as sysdba;

3. Create a user

Create user Username identified by password;

4. Grant dba permissions to users

Grant connect, resource, dba to user name;

5. Import database

Run the following command in cmd:

Import the entire database to a user

Imp username/password @ database name full = y file = d: \ *. dmp ignore = y

Import a table to the user

Imp username/password @ database name file = d: \ *. dmp tables = (table name)

At this point, the Oracle database has been exported and imported, and the deployment is expected to be completed normally tomorrow.

Related Article

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.