[oracle 10g]ÁÙʱ±í¿Õ¼äµÄÅä¶î¹ÜÀí

create tablespace data datafile '/opt/app/oracle/oradata/data.dbf' 
size 50M EXTENT MANAGEMENT LOCAL;


CREATE TEMPORARY TABLESPACE TEMP
    TEMPFILE '/opt/app/oracle/oradata/tmp.dbf' SIZE 5M
EXTENT MANAGEMENT LOCAL;

create tablespace index datafile '/opt/app/oracle/oradata/index.dbf'
size 50M EXTENT MANAGEMENT LOCAL;


create user star identified by star default tablespace data temporary tablespace temp;

grant resource,connect,dba to star with admin option;

alter user star
      quota 16K on system
      quota unlimited on data
      quota unlimited on temp
      quota unlimited on index;

--Í˳öSQLPLUS
exit;


Ö´Ðе½alter user star quota unlimited on temp ʱ±¨´í...

ÁÙʱ±í¿Õ¼ä²»ÄܽøÐÐÅä¶î¹ÜÀíô?

---

¸Õ¿´ÁËһϣ¬ºÃÏñ²»¿ÉÒÔ

---

ÒýÓÃ

You can assign each user a tablespace quota for any tablespace (except a temporary tablespace).

ѧϰ

---

¿´À´¹ûÈ»ÊÇ´Ó9iÉýµ½10g²ÅÓеÄÕâ¸öÎÊÌâ...

¼ÈÈ»²»ÄܽøÐзÖÅäµÄ»°,
ÄÇÒ²¾ÍÊÇ˵ûÓбØҪȥ½¨Á¢Õâ¸öÁÙʱ±í¿Õ¼äÁË?

ÎÊÌâÓеãС°×ÁË,Ö»ÊÇÆæ¹ÖÕâô¹æ¶¨µÄÀíÓÉ...

---

ÔÙ¶¥¶¥

---

ÒýÓÃ

¼ÈÈ»²