From: "Tracy Rahmlow" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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@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: <[EMAIL PROTECTED]>
X-Comment: Oracle RDBMS Community Forum
X-Sender: "Tracy Rahmlow" <[EMAIL PROTECTED]>
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [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).
_________________________________________________________________
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: [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).
