Do you have an open cursor on the table? Do you have static on? Are you declaring the table as temp when you create it?
Troy >===== Original Message From [EMAIL PROTECTED] ===== >Hello wizards. > >I have a rather "simple" problem. My application creates a temporary table to >do some data crunching. To clear the table before I start, I could just delete >all the rows, or drop the table and recreate it. When I try to drop the >temporary table (even if I am in single user mode), I get the follwing evil >error message.... >-ERROR- This operation cannot be performed because table MEDLIST4 is in >use.(2931) > >To get rid of it, I have to disconnect and reconnect the database. Is this >normal? Why can't I drop a temporary table in single user mode???? > >TIA! > >Mike Sinclair Troy Sosamon Denver Co [EMAIL PROTECTED]
