Re: Question on Installing Oracle.

I absolutely agree. And I believe (but don't quote me) that in 9i, the create database syntax *does* now create additional tablespaces. Last I heard, it creates a temporary tablespace, which becomes the temporary tablespace by default of all new users; and it creates a rollback tablespace, in which it creates (and subsequently manages) all rollback segment requirements, automatically.

Still no tablespace for the users, though.

And I may have got all this wrong... there must be some beta testers out there who can confirm or deny the above rumours!

Regards
HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"I hate Spam" <tbf_at_cn.stam.dk> wrote in message
news:7mpagtki57dnjcdluph215s2ml4oi87j48_at_4ax.com...


> On Wed, 16 May 2001 07:04:05 +1000, "Howard J. Rogers"

> <howardjr_at_www.com> wrote:

>

> >A moments thought or understanding of the create database syntax would

> >indicate that there is only ever one tablespace that Oracle absolutely

 knows


> >exists, and knows *must* exist.  And it's SYSTEM, of course.  And if

 that's


>

> You are right of course.

> Maybe it would prevent some misuse of the SYSTEM tablespace if the

> syntax for the 'create database' command was changed to incorporate a

> definition of a "default USER tablespace".

>

> Just a thought.

> Yours Hans Erik Busk

> tbf_at_cn.stam.dk