Change User Default Tablespace in Oracle

1. Check the User default tablespace

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

USERNAME DEFAULT_TABLESPACE

-------- ------------------

TEST       USER

test user using default tablespace user 

2.Change Default tablespace for test user

SQL> alter user TEST default tablespace TEST_DATA;

User altered.

4. Verify the result

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

USERNAME    DEFAULT_TABLESPACE

---------- -------------------

TEST         TEST_DATA