Re: About DBA_SEGMENTS

From: Fred A G <nospam_at_allowed.localhost>
Date: Wed, 6 Jun 2001 19:34:16 +0200
Message-ID: <%MtT6.19129$dj2.331597@news2.bredband.com>

"Victor" <lch_1_at_hotmail.com> wrote in message news:9flms3$so51_at_imsp212.netvigator.com...
> Where does the 'segment_name' of the DBA_SEGMENTS view come from?
>
> It seems no CREATE SEGMENTS statement in Oracle.
>
> THX
>

"Logical" objects in Oracle, e.g. tables, indexes, have their corresponding storage spaces in segments and they use "matching names", i.e. a table called EMP stores its data in a segment named EMP. Perhaps somebody could say that a CREATE some_object_name statement does a 'create segment' implicitly.

Regards
/Fad Received on Wed Jun 06 2001 - 12:34:16 CDT