Re: CONFESSION TIME.

Niall,

We ran into this problem in 8.0.3 EE on AIX 4.3. It was a known bug and we upgraded quickly to 8.0.4. Luckily it was a test db.

Joe

Niall Litchfield wrote:
>
> 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 - 14:56:40 CST