-- 创建 RSMS 表空间
CREATE SMALLFILE TABLESPACE "RSMS" DATAFILE 'C:\oracle\product\10.1.0\oradata\ORCL\RSMS' SIZE 1000M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
-- 创建 RSMS_INDEX 表空间
CREATE SMALLFILE TABLESPACE "RSMS_TEMP" DATAFILE 'C:\oracle\product\10.1.0\oradata\ORCL\RSMS_TEMP' SIZE 500M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
-- 创建 RSMS 用户
CREATE USER "RSMS" PROFILE "DEFAULT" IDENTIFIED BY "rsms20080310" DEFAULT TABLESPACE "RSMS" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "RSMS" WITH ADMIN OPTION;
GRANT "DBA" TO "RSMS" WITH ADMIN OPTION;
----删除用户
drop user "WEB_GZ" cascade;//删除视图
revoke unlimited tablespace from SLJGW;
alter user SLJGW default tablespace SLJGW;
alter user SLJGW quota unlimited on SLJGW;
alter user SLJGW quota 0 on system;