Re: CONFESSION TIME.

Niall Litchfield wrote:
>
> cheers.
>
> Actually it is this handling absurdly large datafiles that I am worried
> about. Anyway we are noww ready to try to recover the tablespace so i'll let
> you all know.
> --
> 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
>
> ******************************************
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
> news:1015522434.29636.0.nnrp-01.9e984b29_at_news.demon.co.uk...
> >
> > You missed
> > Don't use an unsupported (or is it just out of date)
> > version of Oracle ;)
> >
> > Is it possible that Oracle has a little bitty section
> > of code that knows how to handle very large files
> > just so long as you don't resize them ?
> >
> >
> > --
> > Jonathan Lewis
> > http://www.jlcomp.demon.co.uk
> >
> > Next Seminar - UK, April 3rd - 5th
> > http://www.jlcomp.demon.co.uk/seminar.html
> >
> > Host to The Co-Operative Oracle Users' FAQ
> > http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> >
> > Author of:
> > Practical Oracle 8i: Building Efficient Databases
> >
> >
> > Niall Litchfield wrote in message
> > <3c879eee$0$232$ed9e5944_at_reading.news.pipex.net>...
> > >
> > >Flames along the lines of
> > >
> > >1. don't use autoextend
> > >2. don't use oem and
> > >3. don't use NT use a man's operating system are gratefully received
> > >
> > >Windows NT4 sp6a
> > >8.1.6.1 SE database.
> > >OEM 2.2
> > >
> >
> >
> >

There are a few notes on metalink about bugs in Oracle where resize and/or autoextend are allowed to freely go beyond what Oracle can itelf cope with...I don't have the note numbers off-hand, but they all pretty much end with "please do recovery and then apply patch ..."

Charming eh?

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."