ORA-00030: User session ID does not exist
420827Oct 14 2008 — edited Oct 14 2008Hi all,
I runned import in my local database server and after few minutes of runing i want to stop this import, to do that i killed the process running the command and after killed the session on oracle database.
But when i check my database usage, the import session is still active till now, i check in v$session view sid and serial and allinofs for this session are still present. But when i'm trying to kill the session it gives error ORA-00030: User session ID does not exist.
Does anybody can help me how to kill this session or how to remove this session in my session list and active session.
Here bellow the thing i did:
SYS @ abdb1>select serial#||' * '||program from v$session where sid=365;
SERIAL#||'*'||PROGRAM
-------------------------------------------------------------------------------------------
21462 * imp@ab-db1 (TNS V1-V3)
SYS @ abdb1>alter system kill session '365,21462' immediate;
alter system kill session '365,21462'
*
ERROR at line 1:
ORA-00030: User session ID does not exist.
Thanks
Raitsarevo