Re: Trouble dropping tables

I have had this problem with SE several times. Do as follows: 1. Find out the *filename* of the table that is missing. Usually something like xxx_nnn where xxx is your tablename or part of it, and nnn is a sequence number. 2. Use your operating system copy command to copy *any* other table to this file name. Both the .dat and .idx files. 3. Make sure the premissions on the files are set so they can be removed. chmod 777 filename works fine. 4. Now drop the table. It will now work, and all related indexes and whatever gets droped as they should. Informix does not check on the structure of the files when you do a drop table so you can use any file for the data and index files. Don't try anything but drop table though after this procedure :-) Hope this helps. Nils Myklebust > kcj@netcom.com (Kate Juliff) writes: > In article <3v89r8$fjd@cssun.mathcs.emory.edu> Mark.Denham@bbc.co.uk (Mark Denham) writes: > > > >Kate wrote: > > > >>I have a database that I can't save the structure of (with dbschema) as > >>there's a weird table in it and dbschema falls over when it comes to it. > >>I can't drop it as it says it doesn't exist. I can't modify it as it says > >>its not there. Yet it appears in systables. I can't delete from systables > >>where tabname = table's name as it says no permission. How can I get rid > >>of it? > > > >Try deleting the row as user informix. You should also ensure that you get > >rid of any entries in sysindexes and syscolumns etc that relate to this > >table if you are going to do this. I personally do not advocate it unless it > >is your only hope. > > > >You have not mentioned whether the db is SE/Online. > > > > > It's a SE db. And i tried logging on as Informix but got access denied to > the db! > > > >>>> Nils.Myklebust@ccmail.telemax.no NM-data, Dalsbergstien 7, N-0170 Oslo, Norway My opinions are those of my company