DBA Hub

📋Steps in this guide1/1

Change default tablespace of user

-- Get default tablespace of a user:

oracle configurationintermediate
by OracleDba
13 views
1

Change default tablespace of user

-- Get default tablespace of a user: -- Change default tablespace of a user:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
set lines 200
col username for a23
select username,DEFAULT_TABLESPACE from dba_users where username='SCOTT';
USERNAME               DEFAULT_TABLESPACE
----------------------- ------------------------------
SCOTT                          USERS
ALTER USER SCOTT DEFAULT TABLESPACE DATATS;
select username,DEFAULT_TABLESPACE from dba_users where username='SCOTT';
USERNAME               DEFAULT_TABLESPACE
----------------------- ------------------------------
SCOTT                           DATATS

Comments (0)

Please to add comments

No comments yet. Be the first to comment!