Re: About DBA_SEGMENTS

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 7 Jun 2001 12:46:31 +0100
Message-ID: <3b1f69a2$0$12250$ed9e5944@reading.news.pipex.net>

"Giorgos Tsiamitas" <gtsiam_at_gmx.net> wrote in message news:k8uT6.267$3t.9824_at_nreader1.kpnqwest.net...
> > 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.
>

I'd second that. Especially if you consider that you'd end up saying CREATE ROLLBACK SEGMENT does a CREATE SEGMENT implicitly. Looks pretty explicit in that case to me.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Thu Jun 07 2001 - 06:46:31 CDT