Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010

    Unanswered: Problem removing table

    Hi, new to this forum, this is my first post!

    I'm trying to remove a database table but unable to do so. This is what I get...

    SQL Error (-214): Cannot remove file for table (metrica.ericsson_cell_idle_traffic_chan_fr_2_raw_ bak).
    ISAM error: Unexpected internal error

    Has anyone a workaround for getting rid of tables like these?

  2. #2
    Join Date
    Mar 2010

    Reply for problem removing table.

    Which version of INFORMIX?.. SE?.. IDS?
    I had this problem with SE because the tablename in SYSTABLES did not match the file (tablename.dat and tablename.idx) stored in the dbname.dbs directory, so I had to rename the .dat and .idx filenames to matchup with the tablename stored in SYSTABLES, then DROP TABLE tablename so that it could find the renamed .dat and .idx files. The other posibility is that the tablename doesn't exist in SYSTABLES although the .dat and .idx files are present. You can also login as user "informix" and update the row in SYSTABLES for the table in question but that is risky! Remember there also columns associated with the table in SYSCOLUMNS, indexes in SYSINDEXES and other dependencies.

    Frank Computer

Posting Permissions

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