Shulou(Shulou.com)05/31 Report--

This article shows you how to manually delete the database in oracle, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Privileged users can use drop database to delete the database, but at this time the database must be in the MOUNT state, and the database must be loaded in a RESTRICT mode.

1. Log in as a user with sysdba identity at the command prompt. Sqlplus "sys/pwd as sysdba".

2. Looking at the global_name through the data dictionary, you can see whether you have correctly connected to the database to be deleted.

Select * from global_name

3. Close the database to be deleted, shutdown

4. Load the database by restrict, startup restrict mount

5. Delete the database, drop database

Deleting a database in this way deletes only control files, data files, and redo log files, but does not delete folders, registration entries, and configuration files related to the database, and can be restored if you have previously made a cold backup.

The above is how to delete the database manually in oracle. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.