Ask The Real Tom

April 11, 2011



ORA-00600: internal error code, arguments: [ktfa_get_hist_objn]

Filed under: oracle — Tags: , , , — admin @ 1:39 pm

I hade recently some trouble with Flashback Data Archive (Total Recal, FBDA) on Oracle 11.2.0.2

On a dissasciate Statement like:
exec DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA('USER','TABLE');

Following Oracle error occured:
ORA-00600: internal error code, arguments: [ktfa_get_hist_objn]

The problem was a oracle bug. If you name any column in your table “DATE” – FDBA does not work properly.

1 Comment »

  1. Hi there,

    Im presenting on FBDA at the UKOUG conference this year – I was doing some research on bugs in FBDA and found your blog entry! Do you have a bug number/reference for this bug – had a dig on MOS but couldn’t find anything?

    Yours
    -Bob

    Comment by Bob Mycroft — October 12, 2011 @ 3:43 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress