Re: Need help in finding the usernames which belong to particular tablspace
- From: "Anant (DBA)" <shastry17@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 27 Jul 2007 02:02:10 +0530
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@xxxxxxxxx> 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
Other related posts:
