Re: Full export and sequence behaviour in 8i

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_at_singnet.com.sg>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

--
http://www.freelists.org/webpage/oracle-l