Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: objects contained in a datafile
For tables and indexes (similarly for LOB segment and LOB index),
select segment_name, file_id, block_id, blocks from dba_extents where segment_type = 'TABLE' and file_id = &fid select segment_name, file_id, block_id, blocks from dba_extents where segment_type = 'INDEX' and file_id = &fid
For other objects, their definition is in SYSTEM tablespace and there's no way to know which of the multiple SYSTEM datafiles (if multiple) contains it. The size definition becomes fuzzy. But you can look at dba_object_size. (Note that this view takes a while to return anything)
Yong Huang
yong321_at_yahoo.com
"Renato" <rsimonetto_at_replay.it> wrote in message news:<a9or5m$p7c$1_at_fe1.cs.interbusiness.it>...
> how can i see the objects contained in a datafile and the space that they
> use?
> Thank you
Received on Sun Apr 21 2002 - 15:58:22 CDT