Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Location of a table's segments

Re: Location of a table's segments

From: <oratune_at_aol.com>
Date: Fri, 20 Oct 2000 20:37:44 GMT
Message-ID: <8sqaen$pjv$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US