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博客

应用系统按表空间的应用方式使用，表空间的配置