修改用户的默认表空间
我们在创建用户的时候,就应该指定用户的默认表空间,这样,这个用户在创建表的时候,就会缺省地存放到这个表空间。
SQL> select username,default_tablespace from dba_users where username='SCOTT';
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
SCOTT LXTBS
SQL>
SQL> alter user scott default tablespace users;
User altered.
SQL> select username,default_tablespace from dba_users where username='SCOTT';
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
SCOTT USERS
SQL>
SQL> conn scott/tiger;
Connected.
SQL> create table ttt(id int);
Table created.
SQL> select owner,segment_name,tablespace_name from dba_extents where segment_name='TTT' and owner='SCOTT';
OWNER SEGMENT_NAME TABLESPACE_NAME
------------------------------ -------------------- ------------------------------
SCOTT TTT USERS
SQL> show user;
USER is "SYS"
SQL>