In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
I. description of the environment
Friday to tell customers about 11g OCP, do a delete database test in advance, record as follows, knowledge points of your own get ~. There is really a big difference between work and lectures. we should not only know what it is about all kinds of knowledge, but also why it is much more demanding in theory. Come on!
II. Specific operation
There are two main ways to delete a database
1. Use DBCA
2. Use DROP DATABASE
Use the second method to delete the database as follows:
[root@11g-ocp] # su-oracle$export ORACLE_SID=orcl12345678 $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 11 18:36:28 2018Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, Automatic Storage Management, OLAP and Real Application Testing optionsSQL > shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL > startup restrict exclusive force mount;ORACLE instance started.Total System Global Area 1870647296 bytesFixed Size 2254304 bytesVariable Size 503319072 bytesDatabase Buffers 1358954496 bytesRedo Buffers 6119424 bytesDatabase mounted.SQL > drop database Database dropped.Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, Automatic Storage Management, OLAP and Real Application Testing optionsSQL >
You can consider which files have been deleted and which files have not been deleted, and why delete them in the mount state? You can leave me a message.
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.