Re: About DBA_SEGMENTS

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Wed, 06 Jun 2001 19:01:16 +0200
Message-ID: <3B1E61DC.DF25CD5@mytoys.de>

> Where does the 'segment_name' of the DBA_SEGMENTS view come from?
>
> It seems no CREATE SEGMENTS statement in Oracle.

There is no dedicated segment in Oracle, every table, index etc. is a segment which you can see in dba_segments (refer to the doc for further information on Oracle concepts).

Regards,

Knut

-- 
Knut Talman                                     Fon +49 30 72 62 01 411
dba_at_myToys.de                                   Fax +49 30 72 62 01 222
          The degree of normality in a database is inversely             
                    proportional to that of its DBA

Received on Wed Jun 06 2001 - 12:01:16 CDT