Re: About DBA_SEGMENTS

From: Giorgos Tsiamitas <gtsiam_at_gmx.net>
Date: Wed, 06 Jun 2001 17:55:28 GMT
Message-ID: <k8uT6.267$3t.9824@nreader1.kpnqwest.net>

comments embedded

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

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 Received on Wed Jun 06 2001 - 12:55:28 CDT