Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2002
    Posts
    3

    Red face Unanswered: ASE 11.9.2 table corrupt

    after a table corrupt i need to delete 2 data page that are corupt . Someone know a sybase command to delete them.

  2. #2
    Join Date
    Jun 2002
    Location
    Dublin, Ireland
    Posts
    23
    What I do when I am have a corrupt table is the following:

    1. Copy the contents of the corrupt table into a new table.

    i.e select *
    into new_table
    from old_table

    2. Drop the corrupt table.

    3. Rename the new table to the name of the old table using sp_rename.

    4. Drop and re-create views, triggers, stored procedures, indexes, defualts, constraints etc. that reference the new table. Run sp_depends to give you this info.

    Hope this helps.
    Mark Sheehan,
    Senior Sybase DBA

  3. #3
    Join Date
    Jun 2002
    Location
    Dublin, Ireland
    Posts
    23
    What I do when I have a corrupt table is the following:

    1. Copy the contents of the corrupt table into a new table.

    i.e select *
    into new_table
    from old_table

    2. Drop the corrupt table.

    3. Rename the new table to the name of the old table using sp_rename.

    4. Drop and re-create views, triggers, stored procedures, indexes, defualts, constraints etc. that reference the new table. Run sp_depends to give you this info.

    Hope this helps.
    Mark Sheehan,
    Senior Sybase DBA

  4. #4
    Join Date
    Jul 2002
    Posts
    3

    Red face

    I made that but during the copy ASE close my connexion and made a stack trace
    Uninitialized logical page '3249513' was read while accessing object '204527762' in database '6'. Please contact Sybase Technical Support.

  5. #5
    Join Date
    Jun 2002
    Location
    Dublin, Ireland
    Posts
    23
    Well I guess you will have to send the stack trace to Sybase Support, and they will comeback with the next plan of action.

    You could try and copy the table via BCP in/out but I think you will probably run into the same problem when the corrupt data page is read.
    Mark Sheehan,
    Senior Sybase DBA

Posting Permissions

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