Solved: Identifying Oracle tablespaces

Subject: Solved: Identifying Oracle tablespaces
From: bcliver -at- manu -dot- com
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Fri, 16 Jan 2004 16:10:11 -0500

To find out what tablespace is assigned to a user:
select DEFAULT_TABLESPACE from DBA_USERS where username='<name>';

The same query on USER_USERS identifies Oracle users currently connected.

Barry Cliver
Lead Technical Writer
Manugistics, Inc.




Previous by Author: Identifying Oracle tablespaces
Next by Author: Re: 3-variable modeling
Previous by Thread: Re: RH X4 and Word 2003
Next by Thread: Best Word trick I've learned this week


What this post helpful? Share it with friends and colleagues:


Sponsored Ads