Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Myths
Vladimir,
Could you post your CREATE DATABASE
statement to prove it ?
Hemant
"Vladimir Begun" <Vladimir.Begun_at_oracle.com> wrote in message
news:3D056F49.DB9E8C7D_at_oracle.com...
> Hi there
>
> Sometimes cannot post to this newsgroup.
>
> Oracle [8,8i,] 9i SQL Reference/CREATE DATABASE. Datafiles can be
> specified for system tablespace and one can define extent EXTENT
> MANAGEMENT.
> --
> Vladimir Begun
> The statements and opinions expressed here are my own and
> do not necessarily represent those of Oracle Corporation.
>
> "Howard J. Rogers" wrote:
> >
> > As I said elsewhere: I'll buy this, if someone will explain to me how I
can
> > make SYSTEM dictionary managed.
> >
> > I feel a sense of deja vu over this subject, as -with the management
types
> > switched round, of course- I had exactly this sort of thread with a
certain
> > poster to these parts who insisted that he'd created a locally managed
> > SYSTEM tablespace in 8.1.6.
> >
> > So, the same question: how? since dictionary/local management is
anattribute
> > of the tablespace, not the datafile. And 'create database' doesn't have
a
> > 'create tablespace system' command in it.
> >
> > Not saying it can't be done, and maybe there's a piece of doco I need to
> > read. But...
> >
> > Regards
> > HJR
Received on Tue Jun 11 2002 - 10:16:04 CDT