Tracy, Have a look at bug 2475331 / 2410612 RDBMS CONVENTIONAL EXPORT HAS WRONG DATA ON IMPORT This is listed as having happened in 8173. Bug has no details of why or who it might affect. 1. Use direct=true and the problem would not reproduce 2. Set the buffer size 1000000 and the problem would not reproduce.
Note 199416.1 has more info: 8170-8172 not affected. Regards, Bruce Reardon -----Original Message----- Sent: Wednesday, 8 January 2003 10:11 AM 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: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
