Re: Oracle Myths

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

but I think thats only once you've decided upon a system lmt - if you go for a dictionary system, then you can still have dictionary tspaces...(why of course anyone would want to do that is another question)

Cheers
Connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."