Re: Attempt to extend SYSTEM tablespace in Oracle 8i

Many thanks for this.

I did add another datafile, with 100M and it worked ok. But if I add data to a table in system tablespace I still get the Oracle 600 error message. Is this caused because Oracle is still aware of the problem datafile from the previous add datafile command issued? Is there anyway of getting Oracle to ignore
that data file?

Alistair <alistair.thomson_at_sphinxcst.co.uk> wrote in message news:a2m1be$t9a$1_at_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 - 05:49:10 CST