Re: Oracle Myths

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Mon, 10 Jun 2002 07:14:31 +1000
Message-ID: <ae0ggg$7uv$1@lust.ihug.co.nz>

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
Received on Sun Jun 09 2002 - 16:14:31 CDT