1.創(chuàng)建角色
CREATE ROLE "QIUDINGROLE" NOT IDENTIFIED;
GRANT "CONNECT" TO "QIUDINGROLE";
GRANT "DBA" TO "QIUDINGROLE";
GRANT "RESOURCE" TO "QIUDINGROLE";
2.創(chuàng)建表空間
CREATE SMALLFILE TABLESPACE "EXAM" DATAFILE 'D:\work\oracle\oradata\qiuding\EXAM' SIZE 100M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'EXAM'); END;
CREATE SMALLFILE TEMPORARY TABLESPACE "EXAM_TEMP" TEMPFILE 'D:\work\oracle\oradata\qiuding\EXAM_temp' SIZE 100M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,NULL,NULL,NULL,NULL,1,1,NULL,5,'EXAM_TEMP'); END;
3.創(chuàng)建用戶
create user EXAM
identified by "PASSWORD123"
default tablespace "EXAM"
temporary tablespace "EXAM_TEMP"
profile DEFAULT
ACCOUNT UNLOCK;
grant QIUDINGROLE to EXAM;
grant unlimited tablespace to EXAM;
4.創(chuàng)建備份目錄并且付相應(yīng)權(quán)限
create directory dump_dir as 'D:\work\oracle\backup';
grant read,write on directory dump_dir to EXAM;
imp userid=exam/password123@qiuding fromuser=exam touser=exam file=D:\data\dbbak\oracle\20130311\exam\exam.dmp