Check and Change Default Tablespace for User in Oracle

Chack and Change Default Tablespace for User in Oracle

1. Check the User default tablespace

select username,default_tablespace from dba_users where username = 'MDSYS';

USERNAME DEFAULT_TABLESPACE
-------- ------------------
MDSYS SYSAUX

2. In this user MDSYS has the tablespace SYSAUS as default.

3. Change the user Default tablespace

SQL> alter user MDSYS default tablespace SPATIAL_TBS;
User altered.

4. Verify the result

select username,default_tablespace from dba_users where username = 'MDSYS';
USERNAME DEFAULT_TABLESPACE
---------- -------------------
MDSYS SPATIAL_TBS

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.