Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: LMT problems ...

Re: LMT problems ...

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 26 Jul 2002 15:59:41 +1000
Message-ID: <2s509.44175$Hj3.134444@newsfeeds.bigpond.com>


Hi Norman,

Gee you're a trouble maker :)

Do any of these problem tables have anything in common ? Have support made any suggestions as to the reason for the problem if not the bug in question ?

Cheers

Richard
"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7026B0C46_at_lnewton.leeds.lfs.co.uk...
> It's me again!
>
> I've got a new problem on HPUX 11 64bit and Oracle 8.1.7.4 64bit that
> I've raised a TAR on, but I thought you might appreciate a heads up.
>
> I have a number of tables - about 2000 - in LMTs, uniform size too,
> about 130 of them are affected but the problem.
>
> "Alter table x deallocate unused keep n" fails with Ora-00600
> [kcbgcur_2] errors on some but not all tables. This is consistent.
> It looks like bug 1502537, but the trace file and Oracle Support say
> that it isn't.
>
> There is nothing special in the table structure - some tables have a
> LONG while the others don't. No LOBS, CLOBS or BFILES and no user
> defined types either.
>
> Analyze table validate structure is ok.
> Analyze table estimate statistics (the work around for the above bug)
> also works, as does
> Analyze table compute statistics
>
> but still the problem occurs.
>
> I have managed to 'fix' it by creating a dictionary managed tablespace
> and creating the table in there - this time the deallocate works fine
> and there are no errors.
> Oracle Support - who are doing a fine job - have indicated that this is
> a problem on 9i as well - but need to check further.
>
> Enjoy !
>
>
> Regards,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
Received on Fri Jul 26 2002 - 00:59:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US