This user account has been locked since 1 month. No active connections, no active sessions, no db links, no objects are being owned by this user. I revoked all the privileges this (ACOSTA) user had just to be on safer side. But nothing works :( On Mon, Oct 4, 2010 at 10:20 AM, Andy Klock <andy@xxxxxxxxxxxxxxx> wrote: > > > On Mon, Oct 4, 2010 at 10:55 AM, mayur nagarsheth < > mayurpnagarsheth@xxxxxxxxx> wrote: > >> There are no jobs existing with these users. Also, it is not on RAC. >> >> >> >> That is a strange one. Not knowing how your database is set up, is it > possible that ACOSTA connects periodically? Could you try locking the > account, then do the delete? > > alter user acosta account lock; > -- Thanks n Regards, Mayur Nagarsheth Cell : (+1)214-364-8271 http://www.linkedin.com/in/mayurnagarsheth http://lyle.smu.edu/~mnagarshet/