From: "Fred A G" <nospam@allowed.localhost>
Newsgroups: comp.databases.oracle.server
References: <9flms3$so51@imsp212.netvigator.com>
Subject: Re: About DBA_SEGMENTS
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <%MtT6.19129$dj2.331597@news2.bredband.com>
Date: Wed, 6 Jun 2001 19:34:16 +0200
NNTP-Posting-Host: 213.112.14.242
X-Complaints-To: news-abuse@bredband.com
X-Trace: news2.bredband.com 991848635 213.112.14.242 (Wed, 06 Jun 2001 19:30:35 CEST)
NNTP-Posting-Date: Wed, 06 Jun 2001 19:30:35 CEST
Organization: A customer of B2 Bredbandsbolaget (www.bredband.com)



"Victor" <lch_1@hotmail.com> wrote in message
news:9flms3$so51@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