Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Table/Index corruption check
- Thread starter craig322
- Start date
Hi,
If you would like to scan a single table for possible page corruption execute statement:
oncheck -cDI testdb:table1
Obviously, to scan all tables:
oncheck -cDI testdb
But it is not suggested, to improve the performance of the checking process, instead unload table names from the systables and generate script, like:
unload to 'check.sql'
select 'oncheck -cDI testdb:'||tabname||';' from systables where tabid>99
Regards,
Shriyan
If you would like to scan a single table for possible page corruption execute statement:
oncheck -cDI testdb:table1
Obviously, to scan all tables:
oncheck -cDI testdb
But it is not suggested, to improve the performance of the checking process, instead unload table names from the systables and generate script, like:
unload to 'check.sql'
select 'oncheck -cDI testdb:'||tabname||';' from systables where tabid>99
Regards,
Shriyan
- Status
Similar threads
- Locked
- Question
- Locked
- Question