I have a database in which I need to drop and recreate a table. I cannot, because the table has a cursor lock on it. I don't know where the lock is coming from because no one is using this table (it is not accessible from the user menus -- it's under development).
I need to get rid of the lock. I assume that getting everyone out and connecting in single user mode will do the trick, but that's difficult at this 24 x 7 installation (I'll try to do it at lunchtime). Does anyone know A) where this lock might be coming from and B) if there is any trick I can use with other users in the database to force R:Base to clear that lock? -- Larry
