Re: to create a non-SYSTEM tablespace

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: Mon, 28 May 2001 21:31:46 +0800
Message-ID: <9etqvn$hue$2@news.seed.net.tw>

"Dino Hsu" <dino1_at_ms1.hinet.net> ????? news:v1hvgto3lb40mo6v5hjffa48a2e2emkmk2_at_4ax.com...
> Dear all,
>
> In a book, it says:
> "In order to create non-SYSTEM tablespaces, you must first create a
> second rollback segment within the SYSTEM tablespace."
>
> Can anyone explain this? Thanks in advance.

It's (maybe?) just an issue on older versions. However, it is still listed in the Orace8i SQL Reference manual. A document bug.

At least, on Oracle 8.1.5, it's not true. You can create a tablespace, create tables on this tablesapce, even though there are only one SYSTEM rollback segment. But, if you want to insert data into the tablespace, there must be at least 2 rollback segments.

Try it by yourself! Received on Mon May 28 2001 - 08:31:46 CDT