Bouncing is mot possible as it is a production database. No flashback enabled. On Wed, Oct 6, 2010 at 9:53 AM, Bill Zakrzewski <bill@xxxxxxxxxxxx> wrote: > Have you (are you able to?) bounced the database and then attempt to drop > the user? > > > On Oct 6, 2010, at 10:46 AM, mayur nagarsheth wrote: > > 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/ <http://lyle.smu.edu/%7Emnagarshet/> > > > -- Thanks n Regards, Mayur Nagarsheth Cell : (+1)214-364-8271 http://www.linkedin.com/in/mayurnagarsheth http://lyle.smu.edu/~mnagarshet/