Export/Import Error and Validation !!!

From: Tracy Rahmlow <tracy.rahmlow_at_aexp.com>
Date: Tue, 07 Jan 2003 15:11:16 -0800
Message-ID: <F001.0052955F.20030107151116@fatcity.com>

We attempted to reorg a table and data corruption resulted. We have isolated the issue and currently have a tar open with Oracle. But basically, when we export the table with a buffer=10485760 the import process corrupts the data. The row count matches, however some fields that initially were null now contain data (there were some other odd data issues in addition). No errors were produced during either the export or import process. When we used a buffer=65536 the table data was correct. This is reproducable. Has anybody seen this before? (AIX 4.3.3 / Oracle 8.1.7.3) Can the buffer size be set too high?

In addition, are there any audits that we can employ to catch such an error? For example, row counts were the same prior and post the process. Are there other things that can be checked. How do others validate that a reorg was successful? We were thinking about executing a data compare through sql of the old and newly reorged table. This seems excessive and not practical for very large tables. Thanks

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Tracy Rahmlow
  INET: tracy.rahmlow_at_aexp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 07 2003 - 17:11:16 CST