OraFAQ Forum: SQL & PL/SQL » Objects in a Tablespace

Home » SQL & PL/SQL » SQL & PL/SQL » Objects in a Tablespace

Tue, 27 February 2007 08:07

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.

Tue, 27 February 2007 08:22

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Look at DBA_SEGMENTS for that tablespace.

Tue, 27 February 2007 09:03

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: Fri Dec 06 18:20:17 CST 2024