Re: Full export and sequence behaviour in 8i
Date: Mon, 16 Mar 2009 09:35:12 +0000
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 <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-lReceived on Mon Mar 16 2009 - 04:35:12 CDT