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

This article will explain in detail how to delete the database in Oracle 11. The quality of the article is high, so Xiaobian shares it with you as a reference. I hope you have a certain understanding of relevant knowledge after reading this article.

1-SID of the import database, if not defined

export ORACLE_SID=database2-Connect database with OS authentication [oracle@Oracle11 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 1 17:38:02 2014Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.3-Start database instance SQL> startup ORACLE instance started.Total System Global Area 3340451840 bytesFixed Size 2217952 bytesVariable Size 1828718624 bytesDatabase Buffers 1493172224 bytesRedo Buffers 16343040 bytesDatabase mounted.Database opened.4-Shutdown database SQL> shutdown immediate; Database closed.Database dismantled.ORACLE instance shut down.5-Start exclusive mode SQL> startup mount exclusive restrict ORACLE instance started. Total System Global Area 3340451840 bytesFixed Size 2217952 bytesVariable Size 1828718624 bytesDatabase Buffers 1493172224 bytesRedo Buffers 16343040 bytesDatabase mounted.6-Delete database SQL> drop database;

Database dropped. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options How to delete a database in Oracle 11 is shared here. I hope the above content can be of some help to everyone and can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

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.