SQL Loader Oracle 8 bug???

From: Gary Eckhardt <Gary_Newsmail_at_dci-ltd.com>
Date: 1998/10/27
Message-ID: <tOqZ1.1257$jE5.191738@client.news.psi.net>#1/1

Hi All,

I received this mail message from a business associate, and I've never heard anything about it. Has anyone else? This is a great impact because we're currently migrating our DB to 8.0.4.1 and perform direct loads exclusively.

Thanks for any information.

cut here ----- cut here ----- cut here ----- cut here -----

Please be aware, and make other interested parties aware (developers) that a high impact alert has been issued for Oracle8.

The bug is generic across all platforms and results is data dictionary corruption. It is fixed in 8.0.5.

The nature of the bug is that when a SQLLoader direct load is interrupted the data dictionary is corrupted with incorrect segment header information. Corruption of this sort would require a point in time recovery or a complete rebuild of the database.

The workaround is to always use conventional loads or ensure that direct loads are not interrupted or killed. Received on Tue Oct 27 1998 - 00:00:00 CST