Re: newbie thrown in the Oracle fire

From: Fred A G <nospam_at_allowed.localhost>
Date: Mon, 19 Feb 2001 23:22:58 +0100
Message-ID: <40hk6.3157$hi2.8990@nntpserver.swip.net>

<vlaurent_at_networkusa.net> wrote in message news:3a918f19.22905516_at_news.ssmhc.com...
> I have been tasked to install Oracle 8.1.7 and set a few things up. I
> did the generic install since I haven't done and install before. Now
> a few issues are cropping up:
>
> I used the default tablespace of system for the install. Now I read
> on-line: " I scarcely need repeat the cardinal rule that other than
> the data dictionary nothing should be allowed in the SYSTEM tablespace
> that can possibly go elsewhere. In particular, no user, other than
> SYS, should have SYSTEM as their DEFAULT TABLESPACE. And no user, not
> even SYS, should have SYSTEM as their TEMPORARY TABLESPACE." This
> is the default, which I did. I see problems here.
>

On a side note, Oracle themselves seems to break that rule. The database batch creation of 8.1.7 creates SCOTT and some other example users with SYSTEM as temp tablespace. Has this been so with previous 8.1 releases? (And shouldn't TEMP be the 'System temp tablespace'?)

Regards
/Fad Received on Mon Feb 19 2001 - 16:22:58 CST