• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 807
  • Last Modified:

how to make table or index corrupt ('suspect') in Sybase

I know it sounds crazy, but I'm testing some scripts to detect suspect tables and indexes in Sybase and I'm wondering how to deliberately force a table or index into suspect or corrupt status.  Any ideas?
0
schumacr
Asked:
schumacr
1 Solution
 
gamaerteCommented:
Well Mr Crazy,

Try fetching the on-disk placement(I don't have a Sybase engine on site , nor documentatio,which means I can't tell you which system table provides you this information) from one of those indexes /tables and alter it with a hex editor .
and do a select on that table to make the engine "see" it is corrupt.

But doing that will make your database corrupt , and you will need to restore.

Greetings

gamaerte
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - Answered by: gamaerte  
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
JgouldCommented:
Question has been closed as per recommendation

JGould-EE Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now