添加user表空间

添加user表空间，并使得
区有本地管理，每次增长固定大小 
段自动管理
设user表空间为默认表空间

点击(此处)折叠或打开

1. SQL> create tablespace users datafile \'/u01/app/oracle/oradata/PROD/disk3/user01.dbf\' size 10m extent management local uniform size 1024k segment space management auto;
   
2. 
   
3. Tablespace created.
   
4. 
   
5. SQL> alter database default tablespace users;
   
6. 
   
7. Database altered.
   
8. 
   
9. SQL> select username , default_tablespace , temporary_tablespace from dba_users;
   
10. 
    
11. USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
    
12. ------------------------------ ------------------------------ ------------------------------
    
13. OUTLN SYSTEM TEMPTS
    
14. SCOTT USERS TEMPTS
    
15. SYS SYSTEM TEMPTS
    
16. SYSTEM SYSTEM TEMPTS
    
17. TSMSYS USERS TEMPTS
    
18. DIP USERS TEMPTS
    
19. DBSNMP SYSAUX TEMPTS
    
20. 
    
21. 7 rows selected.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29598413/viewspace-1140966/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29598413/viewspace-1140966/