ORA-01940: cannot drop a user that is currently
Oracle deletes a user and reports an error:
12:17:05 SYS@RCBD1 (BAPRCDB) > drop user GSDPAY cascade
Drop user GSDPAY cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
After using to delete the current user session, the link has been changing and rising.
12:21:13 SYS@RCBD1 (BAPRCDB) > select 'alter system kill session''| | sid | |','| serial# | |''; 'from v$session where username =' GSDPAY'
'ALTERSYSTEMKILLSESSION''' | | SID | |','| | SERIAL# | |'';'
Alter system kill session '39pm 25167'
Alter system kill session '144pm 15001'
Alter system kill session '155pm 31897'
Alter system kill session '297, 27285'
Alter system kill session '478, 61659'
Alter system kill session '1043. 54247.
Alter system kill session '1427747505'
Alter system kill session '1565 and 1707'
Alter system kill session '1608. 4123.
Alter system kill session '161509605'
Alter system kill session '1728,34805'
Alter system kill session '1886 and 5755'
Alter system kill session '2005. 36393'
Alter system kill session '2023 and 62813'
Alter system kill session '2034, 17133'
Alter system kill session '2154. 36941'.
Alter system kill session '2297, 57457'
Alter system kill session '2310pr 34881'
Alter system kill session '2321, 4779'
Alter system kill session '2427pr 5759'
Alter system kill session '2461 Magi 19827'
Alter system kill session '2569pm 56201'
Alter system kill session '2721, 45675'
Alter system kill session '2844CA 19895'
Alter system kill session '2851 par 63481'
Alter system kill session '2984 51063'
Alter system kill session '29999944415'
Alter system kill session '3319, 40307'
Alter system kill session '3450pc8641'
Alter system kill session '3700, 27449'
Alter system kill session '3859pm 35379'
Alter system kill session '3884pm 54613'
Alter system kill session '4265, 62259'
Alter system kill session '4276 and 38659'
Alter system kill session '4428,22593'
Alter system kill session '4438pr 55087'
36 rows selected.
This is not the problem, try to delete the user tablespace
12:24:57 SYS@RCBD1 (BAPRCDB) > select default_tablespace from dba_users where username='GSDPAY'
DEFAULT_TABLESPACE
GSDPAY_DATA
12:25:05 SYS@RCBD1 (BAPRCDB) > drop tablespace GSDPAY_DATA including contents and datafiles
Tablespace dropped.
12:29:08 SYS@RCBD1 (BAPRCDB) > drop user GSDPAY cascade
Delete successfully, a good memory is not as good as a bad pen, record
