From: "Giorgos Tsiamitas" <gtsiam@gmx.net>
Newsgroups: comp.databases.oracle.server
References: <9flms3$so51@imsp212.netvigator.com> <%MtT6.19129$dj2.331597@news2.bredband.com>
Subject: Re: About DBA_SEGMENTS
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <k8uT6.267$3t.9824@nreader1.kpnqwest.net>
Date: Wed, 06 Jun 2001 17:55:28 GMT
NNTP-Posting-Host: 195.43.96.247
X-Complaints-To: abuse@Belgium.EU.net
X-Trace: nreader1.kpnqwest.net 991850128 195.43.96.247 (Wed, 06 Jun 2001 19:55:28 MET DST)
NNTP-Posting-Date: Wed, 06 Jun 2001 19:55:28 MET DST
Organization: KPNQwest customer news service


comments embedded

"Fred A G" <nospam@allowed.localhost> wrote in message
news:%MtT6.19129$dj2.331597@news2.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",

Exactly.

> 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.

One could say that, but would cause confusion. There is no "create segment"
statement. What happens behind the scenes when you create objects is
explained (here and there) in Oracle Concepts.

To come back to Victor's post, you should always check owner and
segment_type columns along with segment_name column in dba_segments to
identify completely the object corresponding to the segment.

Rgrds,
Giorgos