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

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.