添加user表空间,并使得
区有本地管理,每次增长固定大小
段自动管理
设user表空间为默认表空间
区有本地管理,每次增长固定大小
段自动管理
设user表空间为默认表空间
点击(此处)折叠或打开
- 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;
-
- Tablespace created.
-
- SQL> alter database default tablespace users;
-
- Database altered.
-
- SQL> select username , default_tablespace , temporary_tablespace from dba_users;
-
- USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
- ------------------------------ ------------------------------ ------------------------------
- OUTLN SYSTEM TEMPTS
- SCOTT USERS TEMPTS
- SYS SYSTEM TEMPTS
- SYSTEM SYSTEM TEMPTS
- TSMSYS USERS TEMPTS
- DIP USERS TEMPTS
- DBSNMP SYSAUX TEMPTS
-
- 7 rows selected.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29598413/viewspace-1140966/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29598413/viewspace-1140966/