-- 創(chuàng)建 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 ;
-- 創(chuàng)建 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 ;
-- 創(chuàng)建 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;