Could you be hitting bug 2410612 : CONVENTIONAL EXPORT HAS WRONG DATA ON
IMPORT?
>From: "Tracy Rahmlow" <tracy.rahmlow_at_aexp.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Export/Import Error and Validation !!!
>Date: Tue, 07 Jan 2003 15:11:16 -0800
>MIME-Version: 1.0
>Received: from newsfeed.cts.com ([209.68.248.164]) by
>mc4-f33.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Tue, 7 Jan
>2003 15:51:57 -0800
>Received: from fatcity.UUCP (uucp_at_localhost)by newsfeed.cts.com
>(8.9.3/8.9.3) with UUCP id PAA29480;Tue, 7 Jan 2003 15:50:25 -0800 (PST)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00529564;
>Tue, 07 Jan 2003 15:11:16 -0800
>Message-ID: <F001.00529564.20030107151116_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: "Tracy Rahmlow" <tracy.rahmlow_at_aexp.com>
>Sender: root_at_fatcity.com
>Errors-To: ML-ERRORS_at_fatcity.com
>Organization: Fat City Network Services, San Diego, California
>X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
>Precedence: bulk
>Return-Path: root_at_fatcity.cts.com
>X-OriginalArrivalTime: 07 Jan 2003 23:51:57.0886 (UTC)
>FILETIME=[C3B2BDE0:01C2B6A7]
>
>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).
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: arupnanda_at_hotmail.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 - 21:43:46 CST
