oracel导入数据库dmp步骤

oracel导入数据库步骤
1、建表空间
2、建用户
4、导入

-- 建表空间 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; 
alter database datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\db\TS_QDPT_MH_DATA.dbf' autoextend on next 1024m; 

--索引的表空间. 

create tablespace TS_DQPT_MH_IDX datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\db\TS_DQPT_MH_IDX.dbf' size 4096m; 
alter database datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\db\TS_DQPT_MH_IDX.dbf' autoextend on next 2048m; 

-- 建用户 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 
grant unlimited tablespace to db_user1; 

----导入 

imp db_user1/db_user1@GDDSPDCHECK187 file='F:/db/sc.dmp' log='F:/db/sc.log' fromuser='db_user1' touser='db_user1' 

--删除用户

drop user <span style="font-family: Arial, Helvetica, sans-serif;">db_user1 </span><span style="font-family: Arial, Helvetica, sans-serif;">cascade</span>

转载于:https://www.cnblogs.com/zhqhlbt/p/4190619.html