Wednesday, October 23, 2024

How do I drop an Oracle database including datafiles

 

How do I drop an Oracle database including datafiles?

1. Make a connection with the database as a sys user.

[oracle@db01 ~]$export ORACLE_SID=CDB
[oracle@db01 ~]$sqlplus '/ as sysdba'

2. Shutdown the database.

SQL> shu immediate

3. Start Database in Exclusive mode till mount stage. Start the process to drop the oracle database manually.

SQL> startup mount exclusive restrict;

4. Now Drop the Database.

SQL> drop database;

CDB database has been dropped successfully.

0 comments :

Post a Comment

Note: Only a member of this blog may post a comment.