default and temporary

How we will find the default and temporary tablespace for a schema..
vangogpeterAsked:
Who is Participating?
 
Wasim Akram ShaikCommented:
select default_tablespace,temporary_tablespace from dba_users where username=<user_name>
0
 
slightwv (䄆 Netminder) Commented:
>>How we will find the default and temporary tablespace for a schema..

select USERNAME, DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE from dba_users where username='SOMESCHEMA';

or if connected as the schema owner:
select DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE from user_users ;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.