Para dropar o banco de dados da instância do Oracle é preciso realizar algusn procedimentos além do DROP DATABASE, para realizar tal tarefa basta seguir os passos abaixo:
1 – Digite o comando shutdown abort
SYS@bd120 AS SYSDBA> shutdown abort;
ORACLE instance shut down.
2 – Inicie o banco no estado MOUNT:
SYS@bd120 AS SYSDBA> startup force mount;
ORACLE instance started.
Total System Global Area 1.0689E+11 bytes
Fixed Size 2265864 bytes
Variable Size 5.1808E+10 bytes
Database Buffers 5.4761E+10 bytes
Redo Buffers 323678208 bytes
Database mounted.
3 – Mudar o banco para o restricted mode através do comando alter system enable restricted session:
SYS@bd120 AS SYSDBA> alter system enable restricted session;
Verificar se o banco mudou o status:
SYS@bd120 AS SYSDBA> SELECT logins from v$instance;
LOGINS
———-
RESTRICTED
4 – O banco estando em MOUNT e RESTRICTED, basta digitar DROP DATABASE e aguardar o banco ser dropado:
SYS@bd120 AS SYSDBA> drop database;
Database dropped.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Esses são os passos necessários para dropar um banco de dados no ORACLE.
