OraFAQ Forum: SQL & PL/SQL » Query to get default tablespace of Current User

Home » SQL & PL/SQL » SQL & PL/SQL » Query to get default tablespace of Current User

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query to get default tablespace of Current User [message #480815]

Wed, 27 October 2010 07:15

manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

Hey guys,

I need query to retrive the default tablespace of the current user, when the user is not a dba, i.e. user doesn't have access to dba_users table.

Kindly help me.

Thanks.

Report message to a moderator

Re: Query to get default tablespace of Current User [message #480818 is a reply to message #480815]

Wed, 27 October 2010 07:22

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

user_users.DEFAULT_TABLESPACE

ind> select comments
  2  from dict where table_name='USER_USERS';

COMMENTS
---------------------------------------
Information about the current user

1 row selected.

ind> select DEFAULT_TABLESPACE     
  2  from user_users;

DEFAULT_TABLESPACE
------------------------------
DATA

[Updated on: Wed, 11 May 2011 06:31] by Moderator

Report message to a moderator

Re: Query to get default tablespace of Current User [message #480819 is a reply to message #480818]

Wed, 27 October 2010 07:25

manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

Thanks a lot for giving me the solution in no time.

Report message to a moderator

Previous Topic:	manager lookup
Next Topic:	Is it possible to avoid encoding dealing when storing CLOB to file system?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 19 01:23:58 CDT 2025