true especially as I was resizing *downwards* to avoid filling the f'ing
disk.
"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:3C87BAE2.17BB_at_yahoo.com...
> 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..."
Received on Thu Mar 07 2002 - 13:20:29 CST
