Re: bad page

thanks for the tips guys !!!! "bozon" <curtis@crowson1.com> schreef in bericht news:1145303901.622126.233710@g10g2000cwb.googlegroups.com... > Danny De Koster wrote: >>You would need to unload around the bad data page. > > Unload to good.out select rowid from <table>;> > If this errors the last rowid in the table should be your last good > before the bad page. > > then try to select rowid > than this until you get to the max rowid or > you don't have any errors. This will be the first good rowid after the > bad page. > > Then unload the records with the following > > unload to good_recs.out select * from <table> where rowid not between> <first_bad_page> and <last_bad_page> ; > > You have all of the data that you can get without doing a restore > before the page was corrupted and rolling the logs. >