Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Kill session

711499Oct 14 2009 — edited Oct 14 2009

Hi friends,

My Oracle import session hung last night, so I logged out of that session. Tried to drop the user that I was importing, said user was connected. I checked the sessions and my import session is still connected and shows active. WHen I try to kill the session I get this error:

SQL> alter system kill session '83,5040' immediate;
alter system kill session '83,5040' immediate
*
ERROR at line 1:
ORA-00030: User session ID does not exist.

Any suggestions please? I need to drop this user and try with the import again..

Thank you

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 11 2009

Added on Oct 14 2009

#general-database-discussions

7 comments

2,044 views