貓熊打滾

create tablespace <tablespace_name>
datafile <file_name> size <file_size>
default storage (<儲存格式>)
online | offline

<儲存格式>包含
    initial 初始區段大小
    next 下個區段大小
    minextents 最小區段數(次數)
    maxextents 最大區段數(次數)
    pctincrease 第二區段後,每區段比前一區段增長百分比

EX
1.Linux
  create tablespace my_space
  datafile '/opt/oracle/oradata/my_space/myspace.ora' size 100M
  default storage (initial 10k next 50k minextents 1 maxextents 9999
  pctincrease 10)
2.windows
  create tablespace mis_space
  datafile 'C:\oracle\product\10.2.0\oradata\mis_space\mis_space.ora' size 100M
  default storage (initial 10k next 50k minextents 1 maxextents 9999
  pctincrease 10)

---------不用設定TEMPORARY TABLESPACE，因為8i以後就不用設------------------
create user hankce
    identified by xxxxx
    default tablespace my_space
    temporary tablespace temp   xxxx
    quota 50M on my_space
   quota 5M on temp               xxxx
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
ERROR at line 1:
ORA-30041: Cannot grant quota on the tablespace
嗯~在官網查了一下..
Oracle does not support quotas on TEMP tablespaces.
this was a bug in earlier releases of  Oracle  --  Oracle9.2 &  10gR1,
which allowed the above commands to work. After this is fixed in 10.2,
we correctly get the expected error message.