Re: Is it possible to create a System tablespace with Local managed extent?

"Nuno Souto" <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message news:3aadee08.3085244_at_news-server...
> On Mon, 12 Mar 2001 22:54:18 -0800, "Daniel A. Morgan"
> <dmorgan_at_exesolutions.com> wrote:
>
> >Leaving aside the personal insults and ill-humor for a moment ... I know
> >I too am occasionally guilty of having a short-temper or writing things
> >in jest and not having them taken that way ... I wish to acknowledge
> >that I made a mistake.
>
> Same here. No offence taken, I hope.
>
> >
> > Locally managed system tablespaces are simply not yet possible.
> >
>
> Akshally, given the create tablespace command for SYSTEM is in the
> sql.bsq file, it would be possible to modify it and create said
> tablespace type anyway. Now, it's quite possible that would break
> other things inside ORACLE.

Nuno: this was the first thing I tried yonks ago, and I'm stuffed if I can work out (syntactically, again) how to pull this trick off. If you've done it, I'd love to know how....

8.1.6. on W2K has the first operative line of sql.bsq thus:

create tablespace SYSTEM datafile "D_DBFN"   "D_DSTG" online

... so naturally, I tried changing that to this:

create tablespace SYSTEM datafile "D_DBFN" extent management local uniform size 100K
  "D_DSTG" online

... at which point, when I tried to create a new database, I just got a rude 'create database failed' error message.

So.... I'm still eager to know... what's the syntactical trick? (Although, I confess... at this point in the proceedings, Pauline Hanson is looking a tad more alluring than the prospect of creating a locally-managed tablespace could ever possibly be).

Regards
HJR
>If you feel lucky or have time in your
> hands, go for it. I for one would be interested in trying this out.
> Unfortunately, I don't have an 8.1.7 instance anywhere to try that
> with.
>
> Note that I've reduced the x-posting of this message: this is for
> internal consumption of this group only, if you are listening to it.
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Tue Mar 13 2001 - 04:56:43 CST