cannot remove a table 207

Hi I have got this problem - there is a table 207 in my database which cannot be removed. Any ideas - pls email to me thanks. -- Francis Teo Ee Cheok francis@jnesw.com.sg

In article <81unt2$qbu$1@coco.singnet.com.sg>, "Francis Teo Ee Cheok" <jnesw@singnet.com.sg> wrote: > Hi I have got this problem - there is a table 207 in my database > which cannot be removed. > Any ideas - pls email to me thanks. > > -- > Francis Teo Ee Cheok > francis@jnesw.com.sg Intriguing, but we need more to be able to help. What do you mean it cannot be removed? What version? What platform? What does the systable record for the table look like? What does dbschema report for the table? Myschema? What error message do you get when you try to DROP the table? Post onstat -d output as well as any message log entries from around the time you attempt to drop the table that may be unusual. Anything else that may help us help you. Art S. Kagel Sent via Deja.com http://www.deja.com/ Before you buy.

We had a similar problem. It was caused by an alter table failing or being canceled. The 207 table is the second copy that is created during the alter table In order to fix it, I updated the systables entry for the 207 and and changed the tabname to a useable name. Then I drop the table with the new name. Francis Teo Ee Cheok wrote: > Hi I have got this problem - there is a table 207 in my database > which cannot be removed. > Any ideas - pls email to me thanks. > > -- > Francis Teo Ee Cheok > francis@jnesw.com.sg