Showing posts with label Query to find type of objects available in a tablespace. Show all posts
Showing posts with label Query to find type of objects available in a tablespace. Show all posts
Tuesday, March 17, 2009
Query to find type of objects available in a tablespace
select ds.segment_name,do.object_type,do.status,ds.tablespace_name from dba_segments ds,dba_objects do where ds.tablespace_name='TOOLS'
Subscribe to:
Posts (Atom)