oracle 表空间 角色 用户 导入（技术文档）

1.创建表空间

CREATE SMALLFILE TABLESPACE "RUNTODATA01" DATAFILE 'D:\app\Administrator\oradata\orcl\RUNTODATA01.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

2.删除用户

drop user crm7_yt cascade

3.创建用户

create user crm7_yt identified by "crm7_yt" default tablespace RUNTODATA01;

4.授权用户

grant dba,connect,resource,aq_administrator_role,aq_user_role,authenticateduser to crm7_yt;

5.导入数据库

imp crm7_yt/crm7_yt@ORCL file=D:/dm_crm7_wf20160531.dmp fromuser=crm7_yt touser=crm7_yt ignore=y buffer=1000000