-
Ora-01940
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?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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.
Rgds
Parag
-
Originally Posted by paragp1981
If in RAC env then its better to check in GV$ views.
Yes u are right , that the thing i first missed
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|