Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Myths
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
"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:3D04F2B7.6D00_at_yahoo.com...
> Howard J. Rogers wrote:
> >
> > It's rather stricter than that:
> >
> > SQL> create tablespace blah
> > 2 datafile 'd:\oracle\ora92\db9\blah01.dbf' size 2m
> > 3 extent management dictionary;
> > create tablespace blah
> > *
> > ERROR at line 1:
> > ORA-12913: Cannot create dictionary managed tablespace
> >
> > Regards
> > HJR
> >
> > "Paul Drake" <drak0nian_at_yahoo.com> wrote in message
> > news:1ac7c7b3.0206090751.47ba219_at_posting.google.com...
> > > Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message
> > news:<3CE61F11.3D0B_at_yahoo.com>...
> > > >
> > > > SYSTEM will be a LMT (by default) in 9i.2
> > > >
> > > > hth
> > > > connor
> > >
> > > and the oui/dbca creates it as such by default.
> > >
> > > Paul
>
>
>