Categories
NFT, Trading

We can use the following sql for Datafile Controlfile and Logfile control, we can check it again at the end of the drop process.

SQL> select name from v$datafile;
SQL> select name from v$controlfile;
SQL> select * from v$logfile;

Let’s connect and close the database

SQL> shu immediate;

Let’s open the database in Exclusive Mode Mount mode

SQL> startup mount exclusive restrict;

We can drop.

SQL> drop database;

15 replies on “How To Drop Database Oracle”

Thank you for the sensible critique. Me & my neighbor were just preparing to do a little research on this. We got a grab a book from our area library but I think I learned more from this post. I am very glad to see such wonderful information being shared freely out there.

Leave a Reply

Your email address will not be published. Required fields are marked *

Archives