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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
