创建oracle数据库表空间角色用户的sql语句

创建oracle 数据库表空间，角色，用户的sql语句 1.创建角色CREATE ROLE "QIUDINGROLE" NOT IDENTIFIED;GRANT "CONNECT" TO "QIUD

创建oracle 数据库表空间，角色，用户的sql语句 1.创建角色 CREATE ROLE "QIUDINGROLE" NOT IDENTIFIED; GRANT "CONNECT" TO "QIUDINGROLE"; GRANT "DBA" TO "QIUDINGROLE"; GRANT "RESOURCE" TO "QIUDINGROLE"; 2.创建表空间 safetemp createtablespace datafile 'D:\oracle\product\10.1.0\oradata\localpower\safetemp01.db f' mm 3232 sizeautoextendonnextmaxsizeunlimited loggingextentmanagementlocalsegmentspace ; managementauto CREATE SMALLFILE TABLESPACE "EXAM" DATAFILE 'D:\Soft\oracle\product\10.2.0\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:\Soft\oracle\product\10.2.0\oradata\qiuding\EXAM_temp' SIZE 100M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;