"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)
Received on Wed Jan 23 2002 - 13:15:25 CST
