應用系統按表空間的應用方式使用，表空間的配置

shilei1發表於2013-02-25
create tablespace PT4
datafile '/datafile/oradata/DCTEST/datafile/pt4.dbf' size 200M
autoextend on next 2M maxsize 1024M;

create tablespace CNGL
datafile '/datafile/oradata/DCTEST/datafile/cngl.dbf' size 500M
autoextend on next 2M maxsize 1024M;

create tablespace HWWDK
datafile '/datafile/oradata/DCTEST/datafile/hwwdk.dbf' size 500M
autoextend on next 2M maxsize 1024M;

create user pt4 identified by pt4 default tablespace pt4;
create user cnxt identified by cnxt default tablespace cngl;
create user hwwdk identified by hwwdk defalut tablespace hwwdk;


SQL> grant connect,resource to pt4;

Grant succeeded.

  1* grant connect,resource to cnxt
SQL> /

Grant succeeded.

SQL> grant connect,resource to hwwdk;

Grant succeeded.

　revoke unlimited tablespace from pt4
　revoke unlimited tablespace from cnxt
　revoke unlimited tablespace from hwwdk

alter user pt4 quota unlimited on pt4 ;
alter user cnxt quota unlimited on cngl;
alter user hwwdk quota unlimited on hwwdk;

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/196700/viewspace-754660/，如需轉載，請註明出處，否則將追究法律責任。

相關文章