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;