cannot drop the user

0 pts.
Tags:
Oracle
Oracle administration
Hi, I cannot drop the user. dorp user "USERA" cascade; ORA-01940: cannot drop a user that is currently connected But when I check v$session table. I do not see any USERA. This happens on me several times and every time when I face this, I need to restart my database. Is there any better method to handle this? Also, why it will happen? Did I do anything wrong with it that makes it happen? Anyone got the experience with this? Thanks in advance.
ASKED: July 5, 2006  5:23 PM
UPDATED: July 13, 2006  10:00 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Are there any database links associated with the user in question ?
What version of the DB ?
In some versions there?s an issue with specific duplicated objects (below)

SELECT owner, object_id, object_type, object_name, status
FROM dba_objects
WHERE object_name = ‘SQLPLUS_PRODUCT_PROFILE’;
SELECT owner, object_id, object_type, object_name, status
FROM dba_objects
WHERE object_name = ‘DUAL’;

Ken

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Bozzo999
    Are there any database links associated with the user in question ? What version of the DB ? In some versions there?s an issue with specific duplicated objects (below) SELECT owner, object_id, object_type, object_name, status FROM dba_objects WHERE object_name = 'SQLPLUS_PRODUCT_PROFILE'; SELECT owner, object_id, object_type, object_name, status FROM dba_objects WHERE object_name = 'DUAL'; Ken
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following