Re: Attempt to extend SYSTEM tablespace in Oracle 8i

From: Alistair <alistair.thomson_at_sphinxcst.co.uk>
Date: Wed, 23 Jan 2002 09:55:29 -0000
Message-ID: <a2m1be$t9a$1@thorium.cix.co.uk>

You should have used

sql> alter tablespace system add datafile '<filespec>' size 100M;

The file would have taken on the storage attributes of the original tablespace.

By the way DO NOT delete the 16K file or you might get yourself into a bit of bother!

Alistair

"Jon Anthony" <jon.anthony_at_caspiansoftware.com> wrote in message news:1011779051.10146.0.nnrp-01.9e98708d_at_news.demon.co.uk...
> Used:
> alter tablespace SYSTEM add datafile '<filespec> autoextend on maxsize
> unlimited
>
> Data file would not create, so created the file SYSTEM02.dbf with zero
> length.
>
> Rerun query, SYSTEM02.DBF is now 16 KB in size.
> Add to a table so as to create another extent. No longer getting the out
of
> file space message but get an Oracle 600 error messge.
>
>
Received on Wed Jan 23 2002 - 03:55:29 CST