Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Need help in finding the usernames which belong to particular tablspace
Thank you all gurus!!!,
The information was very much useful. This place is too good for learners once again and it cannot be paid too if somebody thinks of . moreover we see different sorts of ideas and angles of solution :-). and about people's role and their concerns over here. Hats off to all gurus here.
Reg,
Ann
On 7/27/07, Victor Lessa <victor.lessa_at_terra.com.br> wrote:
>
> Select owner,tablespace_name from dba_segments group by
> owner,tablespace_name;
>
> This sql does see all tablespace that this users have objects.
>
> ----- Original Message -----
> *From:* Anant (DBA) <shastry17_at_gmail.com>
> *To:* oracle-l <oracle-l_at_freelists.org>
> *Sent:* Thursday, July 26, 2007 5:32 PM
> *Subject:* Re: Need help in finding the usernames which belong to
> particular tablspace
>
> 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-lReceived on Fri Jul 27 2007 - 02:22:06 CDT
![]() |
![]() |