Re: Need help in finding the usernames which belong to particular tablspace

From: Anant (DBA) <shastry17_at_gmail.com>
Date: Fri, 27 Jul 2007 02:02:10 +0530
Message-ID: <5b294dab0707261332m7569ed52m6f1a4bde4afa0d8e@mail.gmail.com>

Hi all,

Sorry, When i tried to dig more i could find there were no users were added to that tablespace. Please ignore this topic.

Thanks,
Ann

On 7/27/07, Anant (DBA) <shastry17_at_gmail.com> wrote:
>
> Hi all,
> Please help me .
>
> I know a tablespace name and I need to know what are all the users which
> are added to that tablespace.
>
> i tried this to get the users but no use "select username from dba_users
> where tablespance name like '<TS_NAME'> "
> It returned no rows. Thanks in anticipation.
>
> Regards,
> Anant

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 26 2007 - 15:32:10 CDT