Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Location of a table's segments
In article <8sq28p$elm$1_at_paxfeed.eni.net>,
"Mike" <mloftus_at_wyle.com> wrote:
> I have been wondering where in the data dictionary the link exists
between a
> particular table and its extents. I expected to see a link between
> dba_tables or dba_objects and dba_extents but I can't see it!
Obviously, it
> is in the catalog somewhere, but where! DbArtisan can find them . . .
>
> Mike
>
>
You need look no further than DBA_EXTENTS. The SEGMENT_NAME column will be the table name when the SEGMENT_TYPE equals 'TABLE'. There will be one entry for each extent for the table, with EXTENT_ID values starting at 0 and increasing incrementally.
-- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/ Before you buy.Received on Fri Oct 20 2000 - 15:37:44 CDT