Re: Bad Data Page

Sahrul Hidayat writes: > > Unfortunatelly, the backup is containing corrupted data, so i can't = > restore from my backup. > I have tried unload, but it's failed, also have tried dbexport, failed = > when reach this table. > > This table containing 1.7 million rows, i just could unload up to = > 500.000 rows only and then quit (failed). I haven't try drop the index = > 'cos i'm worry, after drop the indexes, i can't re-create again. Try to unload the rowid (if you have them) with the data. When it dies, try an unload "where rowid > ...", bumping up the number until your next unload starts past the bad page. This won't salvage what's on the bad page, but you'll get much more than 500000. -- ______________________________________________________________________ | Colin McGrath cmm@trac3000.ueci.com | | Raytheon Engineers & Constructors, Inc. (215) 422-4144 | | Phila, PA, USA | | Any opinions I state are my own and not necessarily of my employer | |____________________________________________________________________|