We were doing some destructive data cleansing - we knew we'd wreck stuff so before hand we had the DBA take a DB backup (oracle 9i, ARS 6.3 patch 20 running CSS - not that it matters).
After we were done we had a restore of the full database done. Immediately we started getting index errors, etc, so I check the nextid versus the max(c1) for a few tables and found they were out of wack (ie, max(c1) > nextid for a particular table). I know how to fix this of course - it's pretty straightforward SQL and I've had it happen a few times over the years - yet I've never been able to pinpoint a root cause. Has anyone else found out why? The DBA says she dropped all users and objects and then restored so I'd have to assume the synch error occurs before the database is backed up. William Rentfrow Principal Consultant, StrataCom Inc. [email protected] Personal blog: www.williamrentfrow.com O 715-592-5185 C 715-410-8056 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
