Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    9

    Unhappy Unanswered: plz plz some body attend this

    Hi All ,
    I'm using IDS 9.21. Unknowingly I deleted the row of one table (cl_grievance_table) from sysindexes in system catalog,in which indexes information is stored, and also updated the information in sysconstraints of table (cl_grievance_table).When I try to access the table I got an error that system catalog corrupted. But all other tables are working fine. When I try to insert rows in sysindexes and sysconstraints it is not allowing me to do so, saying no insert permission.But I have all previlegaes. Actually it is main table for our project. Some body plz help me how to fix the problem. I'm very thankfull to you.

  2. #2
    Join Date
    Sep 2003
    Posts
    22
    Have you tried re-creating index and constraints on the table mentioned?
    Try that, if that works!!

    -PD

  3. #3
    Join Date
    Oct 2003
    Posts
    9
    thanx for reply. Yes I tried but It is giving Error

    211:Caanot read system catalog(sysindices)

  4. #4
    Join Date
    Nov 2003
    Location
    Pune, India
    Posts
    22
    HI,
    May be u can take a dump of the data in that table,
    drop the same,
    recreate the table and upload the data.
    Regards,
    Amit.K.

Posting Permissions

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