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
Other related posts:
