| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> killing system user
Hi lists,
Solaris 2.7
oracle 8i
I have a session "SYSTEM" doing import into a table. (logged into server thru telnet from win 98 PC)
Suddenly the power outage occurred to my PC.
When I logged into the server thru telnet, I found that the session is
active.
By mistake, I killed the process at o/s level.
For somereasons,I tried to drop the table. But I failed to do it, as it is locked by import process.
I tried to kill the user "SYSTEM". But the oracle is giving error that there is not user with such sid and serial number.
The serial# number is often getting changed when I query from v$session.
Is there a way to kill this user, without shutting down the database.
And why different serial# number each time, I query v$SESSION.?
Any clues?
Thnx and Regards,
Srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: Shrinivas.Tatireddy_at_med.ge.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Dec 03 2001 - 01:13:14 CST
 |
 |