Re: Please Help !!! Can't drop table
Hi Susan,
Please recycle engine and then drop table. What happened
in your case, their is stray lock on that table ( which was created
by some process, when process leave it should cleared but it did not )
that's why you are getting that error.
Thanks,
Susan Elliott (ISG) wrote:
> Howdy folks,
>
> I keep getting the following error when trying to drop a table. I can
> exclusively lock the table and then rollback, I try again to delete the
> table and still get this error message. Does anyone have any ideas on
> how I can get around this, apart from bouncing the engine.....???
>
> FYI,
> Suze.
>
> 214: Cannot remove file for table (ttdsst020001).
> 106: ISAM error: non-exclusive access.>
> Susan Elliott
> Host Team Leader
> ISG
> ( 520 -8608
> * susane@fclcis.co.nz
--
===============================================================
Umesh Patel
On Assignment with Caliber Logistics-
===============================================================