Re: Attempt to extend SYSTEM tablespace in Oracle 8i

Thanks for that. I did try that but still got Oracle 600 error. In the end, an export, rebuild and import solved the problem. Pity there is no drop datafile!!!!!!!

michael ngong <mngong_at_yahoo.com> wrote in message news:ecf365d5.0201231115.238c3b77_at_posting.google.com... > "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3c4ea53f$1$8514$ed9e5944_at_reading.news.pipex.net>...
> > "Jon Anthony" <jon.anthony_at_caspiansoftware.com> wrote in message
> > news:1011786396.18458.0.nnrp-13.9e98708d_at_news.demon.co.uk...
> > > 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?
> > >
> >
> > Undoubtedly the error will be related but ora-00600 means call support.
It
> > is an untrapped error.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************

>
> use alter database datafile<filespec of your 16k file> resize 100M
> You could get a 600 even from anything.
> Hope that helps
> Michael Tubuo Ngong (DBA)