Oracle-dmp file Export Import, get a look?

Oracle Exports DMP Files:

1, fully export database Oracle, export to C:\daochu.dmp
Exp User/[email protected] file=c:\xxx.dmp full=y or exp user/[email PROTECTED]:1521/ORCL file=e:\xxx.dmp

2, export the tables of RfD users and JYZGCX users in the database
Exp User/[email protected] file=d:\xxx.dmp owner= (RFD,JYZGCX)

3, export the table T_user, t_role in the database
Exp User/[email protected] file= d:\data\xxxx.dmp tables= (t_user,t_role)

Oracle Import DMP File:

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

Oracle-dmp file Export Import, get a look?