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.