Re: to create a non-SYSTEM tablespace

yep

If your database has one system rollback segment in the system tablespace then an attempt to issue

create tablespace blah datafile '/blah/blah' size 100m;

will fail with a message along the lines of cannot use system rollback segment for this operation.

you first need to issue the command
create rollback segment tmp;

then create your non-system tablespaces and finally drop (or at least place offline) the tmp rollback segment.

HTH

--

Niall Litchfield
Oracle DBA
Audit Commission UK
"Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message
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.

>

> Dino

>