Dropando usuário ORCL
|
1 |
SYS@ORCL > drop user ORCL cascade; |
Erro ORA-01940
|
1 2 |
ERROR at line 1: ORA-01940: cannot drop a user that is currently connected |
Solução:
Parando
|
1 2 3 4 |
SYS@ORCL > Shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. |
Iniciar em modo restrict
|
1 2 3 4 5 6 7 8 9 10 |
SYS@ORCL > startup restrict; ORACLE instance started. Total System Global Area 1.0689E+10 bytes Fixed Size 2262656 bytes Variable Size 1979713920 bytes Database Buffers 8690597888 bytes Redo Buffers 16900096 bytes Database mounted. Database opened. |
Dropando usuário ORCL
|
1 2 3 |
SYS@NBS > drop user ORCL cascade; User dropped. |
Parando
|
1 2 3 4 |
SYS@ORCL > shut immediate Database closed. Database dismounted. ORACLE instance shut down. |
Iniciando
|
1 2 3 4 5 6 7 8 9 10 |
21:50:44 SYS@ORCL > startup ORACLE instance started. Total System Global Area 1.0689E+10 bytes Fixed Size 2262656 bytes Variable Size 1979713920 bytes Database Buffers 8690597888 bytes Redo Buffers 16900096 bytes Database mounted. Database opened. |
Em outro post mostrarei como matar processo do usuário.