How to import a DMP file into your own Oracle database

1, first, we can first create their own user table space, the format of creating table space is as follows:

Create Tablespace Test (the name of the tablespace)
DataFile ' D:\oracle\product\10.2.0\userdata\test.dbf ' (this side can be written under one of Oracle's paths)
Size 50m (initial size)
Autoextend on; (Auto-expand)

2. Next, we can create a user of our own, creating the following format:

CREATE user utest (user name)
Identified by Upassword (password)
DEFAULT tablespace Test (table space created above)
Temporary tablespace temp; (Temporary tablespace will write temp)

3. Then we need to give our users permission to manage their tablespaces

GRANT CONNECT to Utest;
GRANT RESOURCE to Utest;
GRANT DBA to Utest;--dba is the highest-level permission to create databases, tables, and so on.

The execution environment of the above three statements needs to enter Oralce

How to enter Oracle under CMD

Sqlplus system/Password Enter

4, Next we can import our DMP file into our own table space, import mode

Imp usename/[email protected] full=y file= d:\data\xxxx.dmp ignore=y

Import an instance

Imp Utest/upassword file=d:\20140227.dmp full=y ignore=y (Import the file into the tablespace of our own new user) Note: The execution environment of this statement is the environment when you first enter the command table

How to import a DMP file into your own Oracle database