corrupted objects from database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: corrupted objects from database

  1. #1
    Join Date
    Oct 2000
    Posts
    57

    Anybody could provide the scripts to find out corrupted
    objects (block corruption etc) from the database ?

    thanks

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width