Announcements

Oracle training based on real-time expertise as per industry standards. Upcoming batch details are here.

View batch schedule

Free Oracle mock interview. Register using the link.

Register

#DBAchallenge: submit your questions.

Ask questions
Swipe for more →
Browse by Topic
Latest Posts

    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

    🌟 Proud to be an Oracle ACE Pro! 🚀

    🌟 Proud to be an Oracle ACE Pro! 🚀 I’m excited to share my official Oracle ACE Profile with the Oracle community. 👨‍💻 Mallikarjun ...