oracle 设置默认表空间

SQL> create tablespace tab2           
  2  datafile '/u01/app/oracle/oradata/aircy/tab01.dbf' size 3m;

Tablespace created.

SQL> create tablespace tab3
  2  datafile  '/u01/app/oracle/oradata/aircy/tab02.dbf' size 3m;

Tablespace created.

SQL> create user air identified by air default tablespace tab2;

User created.

SQL> select username, default_tablespace defspace from dba_users where username='AIR';

USERNAME                       DEFSPACE
------------------------------ ------------------------------
AIR                            TAB2

SQL> alter database default tablespace tab3;

Database altered.

SQL> create user chris identified by chris;

User created.

SQL>  select username, default_tablespace defspace from dba_users where username='CHRIS';

USERNAME                       DEFSPACE
------------------------------ ------------------------------
CHRIS                          TAB3

SQL>  select username, default_tablespace defspace from dba_users where username='AIR';

USERNAME                       DEFSPACE
------------------------------ ------------------------------
AIR                            TAB2