Oracel Import Database DMP steps ___ Database

Oracel Import Database steps
1, the establishment of the table space
2, build users
4, Import

--Building table space Ts_qdpt_mh_data

Create tablespace ts_qdpt_mh_data datafile ' D:\ORACLE\PRODUCT\10.2.0\ORADATA\db\TS_QDPT_MH_DATA.dbf ' size 10240m; 

--The table space of the index.

Create tablespace ts_dqpt_mh_idx datafile ' D:\ORACLE\PRODUCT\10.2.0\ORADATA\db\TS_DQPT_MH_IDX.dbf ' size 4096m; 

--Build User Db_user1

--Create 
the user create user Db_user1 
identified by "Db_user1" 
default tablespace ts_qdpt_mh_data 
Temporary tablespace TEMP profile 
DEFAULT; 
--Grant/revoke role Privileges 
Grant connect to Db_user1; 
Grant DBA to Db_user1; 
Grant resource to Db_user1; 
--Grant/revoke System privileges 

----Import

--Delete User

Drop user <span style= "font-family:arial, Helvetica, Sans-serif;" >db_user1 </span><span style= "font-family:arial, Helvetica, Sans-serif;" >cascade</span>