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 01:42:51 +0530
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:
