oracel导入数据库dmp步骤

来源：互联网发布：des算法举例编辑：程序博客网时间：2024/05/22 10:41

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>

0 0