Saturday, May 30, 2020

Drop Database Delete Database manual method or GUI method

Drop Database:

1. GUI Method:

--- Launch dbca and select drop option to drop the database

--- OEM or Grid Control (Only Instance delete)

2. Manual Method:

--- connect to database in mount restrict mode and drop the database

--- shutdown the database and manually delete all the datafiles and configuration file (Not Recommended)

Drop Database possibilities:

open mode - drop database is not possible

mount mode - drop database is not possible

mount exclusive - drop database is not possible

mount restricted - drop database is possible


Please refer the more details in my YouTube channel https://youtu.be/3EWLBLie8-w


Regards,
Mallik

No comments:

Post a Comment

🚀 New Oracle DBA & RAC Batches Starting Soon – Join Us This November!

🙏 We’re excited to announce that a new Oracle DBA batch is starting on Monday, 03-Nov-2025. 👉 For registration, please reach out to me d...