Anybody could provide the scripts to find out corrupted
objects (block corruption etc) from the database ?
thanks
Printable View
Anybody could provide the scripts to find out corrupted
objects (block corruption etc) from the database ?
thanks
You can run DBVERIFY on all data files to check for the corrupted blocks.
Or check in trace file directory where you can find file id and block number. Then you can easily figure out which table is corrupted.