Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Need help in finding the usernames which belong to particular tablspace

Need help in finding the usernames which belong to particular tablspace

From: Anant (DBA) <shastry17_at_gmail.com>
Date: Fri, 27 Jul 2007 01:42:51 +0530
Message-ID: <5b294dab0707261312j3d5dd02bl34ccb12d1eb8ca75@mail.gmail.com> 





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:12:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US