Re: Full export and sequence behaviour in 8i

From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
To: hkchital@xxxxxxxxxxxxxx
Date: Mon, 16 Mar 2009 09:35:12 +0000

Hi

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*.

Niall

On Sun, Mar 15, 2009 at 2:39 PM, Hemant K Chitale
<hkchital@xxxxxxxxxxxxxx>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
http://www.orawin.info

References:

Full export and sequence behaviour in 8i
From: hrishy

Re: Full export and sequence behaviour in 8i
From: Hemant K Chitale

Re: Full export and sequence behaviour in 8i
From: Yechiel Adar

Re: Full export and sequence behaviour in 8i
From: Hemant K Chitale

Re: Full export and sequence behaviour in 8i

Other related posts: