William, what kind of backup is your DBA taking? If I read between the lines it sounds like she's doing an exp/imp. If thats the case you must use the option "consistent=yes". Kind Regards Conny
________________________________ Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von William Rentfrow Gesendet: Montag, 22. Juni 2009 18:42 An: arslist@ARSLIST.ORG Betreff: Root cause of Nextid out of wack after DB restore ** 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. wrentf...@stratacominc.com Personal blog: www.williamrentfrow.com <file://www.williamrentfrow.com> O 715-592-5185 C 715-410-8056 _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
