So, just to get specific, I could delete the contents of the JOURNAL table and change REVISION_ID in GLOBAL_REVISION to 0?
While making sure no one was connected to the DB. -mike > -----Original Message----- > From: Guo Du [mailto:[email protected]] > Sent: Monday, February 08, 2010 4:11 PM > To: [email protected] > Subject: Re: Revision cleanup > > On Mon, Feb 8, 2010 at 8:26 PM, Michael Yin <[email protected]> > wrote: > > I was thinking about exporting to XML then reimporting into a clean > > repo, but there must be a better way than that. > > Version history stored in separate table, I think you may simple run > sql to delete all record in the version table after you stopped the > repository instance. > > Then delete the index before start the repository. > > Never try this, take a safe backup before any action :) > > -Guo
