LMT problems ...

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 25 Jul 2002 16:54:24 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7026B0C46@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 Thu Jul 25 2002 - 10:54:24 CDT