Oracle 11g users create, authorize, and import dmp files

Source: Internet
Author: User

1. recently, I used Oracle many years ago to import oracle dmp files. The technology I used was nearly forgotten over time. Now I mark it here, so as not to feel helpless when you encounter the same problem again.

To import a dmp file, you need to know the user who created the dmp file. Therefore, you must first create a user and authorize it.

(1) User Creation

First, log on to Oracle SQL Developer as a system user

Secondly, in the SQL Worksheet (you can press ctrl + shift + w), enter:

Create user thomas identified by 123456;

The next step is to run this statement. If the running time shown in is displayed, a user is successfully created.

(2) For user authorization, the command is as follows: (all three system roles are assigned to this user)

Grant connect, resource, dba to thomas;

(3) enter the import command in cmd: The specific command is as follows:

Imp thomas/123456 @ orcl file = d: \ student. dmp full = y

(Thomas is your username, 123456 is the password, @ is a required command, orcl is your database instance, d: \ student. dmp is your imported database file, and full = y is a required Parameter

Note: The first slash/is different from the second slash)

After the input is complete, press Enter. A prompt is displayed in oracle. Enter the prompt as prompted.

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.