Re: Full export and sequence behaviour in 8i

From: Niall Litchfield <>
Date: Mon, 16 Mar 2009 09:35:12 +0000
Message-ID: <>


It's certainly true that you do not know what data is missing if any. What you do know is that there is a *possibility* that some data is missing. That would seem to me worthy of investigation - or a different approach *cough* backup *cough*.


On Sun, Mar 15, 2009 at 2:39 PM, Hemant K Chitale <>wrote:

> In the first place, "hrishys" did NOT say that "4 rows are missing and
> each one for a multimillion order"
> He said "Example the seq number is 38 and the table pk has a value of 42".
> A gap of 4 between a Sequence and the Primary Key doesn't always mean that
> 4 rows are missing. Furthermore, the 4 rows could be either for purchase
> orders of 1cent each or for employee usage of the coffee machine.

Niall Litchfield
Oracle DBA

Received on Mon Mar 16 2009 - 04:35:12 CDT

Original text of this message