i have a problem with droping the user.....
it not allowing me to drop the user,saying that the user is currently connected......but there is no sessions opened for that user....??
Printable View
i have a problem with droping the user.....
it not allowing me to drop the user,saying that the user is currently connected......but there is no sessions opened for that user....??
I assume you have check v$session looking for the offending user.
Is the offending user associated with any active jobs?
Do you have replication in place in your environment? does the user owns replication?
There is not active jobs for that user...in the v$session.
No replication, and i checked in v$dblink for any transaction is going on or not...no transaction is there..
Sorry man its my mistake.......:)
i have some session in the node 2...
If in RAC env then its better to check in GV$views.
Yes u are right :) , that the thing i first missed :confused:Quote:
Originally Posted by paragp1981