添加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博客

添加user表空间