Home » SQL & PL/SQL » SQL & PL/SQL » Objects in a Tablespace
Objects in a Tablespace [message #221561] Tue, 27 February 2007 08:07 Go to next message
ganeshsv
Messages: 51
Registered: January 2006
Member
Hi,
Can you please tell me how to find the list of all objects present in a particular tablespace.

Thanks in advance.
Re: Objects in a Tablespace [message #221568 is a reply to message #221561] Tue, 27 February 2007 08:22 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
Look at DBA_SEGMENTS for that tablespace.
Re: Objects in a Tablespace [message #221571 is a reply to message #221568] Tue, 27 February 2007 09:03 Go to previous message
cbruhn2
Messages: 41
Registered: January 2007
Member
Hi ganeshsv,

try

select segment_name from dba_segments where tablespace_name = 'SYSTEM'

best regards
cbruhn2
Previous Topic: java stored procedure with ref cursor
Next Topic: Problem In Loading The CSV File Into The Database
Goto Forum:
  


Current Time: Wed Dec 07 22:21:14 CST 2016

Total time taken to generate the page: 0.23137 seconds