Re: Question on NEXT_CHANGE#
- From: Phil Jones <phil@xxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 30 Dec 2013 17:00:57 +0000
All,
I think this all boils down to the usual question we're all asked when
designing software/DB schemas.
Do you want the numbers to be unique (with possible gaps) or truly sequential?
The database is working correctly, probably using the missing scn numbers
internally - it doesn't matter, but it would be interesting to know why.
Cheers,
Phil
--
//www.freelists.org/webpage/oracle-l
Other related posts:
