Using DBCA command line to delete a database is quite simple:
dbca -silent -deleteDatabase -sourceDB dbSID2delete
The following describes MANUALLY delete a database:
Refrence:
Search "Oracle DBA Justin - How to drop/delete an Oracle database" on YouTube.
http://www.youtube.com/watch?v=NkI2Sbpjaf4
1. set the database SID
export ORACLE_SID=mydb
2. sqlplus / as sysdba
3. make sure it's the correct database to delete
SQL>select name from v$database;
name
---------
mydb
4. shutdown the database
SQL>shutdown immediate;
5. YOU MAY WANT TO BACKUP THE DATABASE NOW
6. start the database not opened
SQL>startup mount restrict;
only control files loaded and restrict other users to sqlplus(logon) the database
7. drop the database now
SQL>drop database;
8. database control files, log files, data files and SPFILES etc would be deleted.
Warning: this is only the steps to drop/delete an Oracle database from the video, it's not yet tested.
分享到：
相关推荐
本资源通过手工创建oracle数据库，比较详细。克服了盲目性，对于教学双方人员学习数据库的创建好处很多，提高的学生的针对性与盲目性。可以帮助学生有效地克服手工创建oracle数据库的恐慌，也减少了教师讲授课程的...
Presto OraclePlugin This is a plugin for Presto that allow ...Oracle Driver is not available in common repositories, so you will need to download it from Oracle and install manually in your repository.
这通常包括Oracle Database Server和Oracle Client组件。在Windows环境下，可以通过Oracle Universal Installer (OUI)进行安装。确保选择合适的版本（如11g、12c或19c）和安装类型（如"Server"或"Client"），根据...
SQL Developer can connect to an Oracle Database irrespective of the database character set and the database national (NCHAR) character set. All functionality which does not involve entering or ...
Manually Cloning Oracle Applications Release 11i with 10g or 11g RAC (Doc ID 760637.1)
- 手动分区（Manually partition with Disk Druid）以确保Oracle有足够的空间。创建以下分区： - /boot: 300M - /: 1500M - swap: 1G - /home: 2G - /tmp: 1G - /usr: 10.5G - 不设置启动密码，直接“Next”...
because 1) many images with similar concepts were not in the same group and 2) some images with different semantic contents were in the same group in the original database. Jul 3, 2009
摘要：We propose an interactive quadrangulation method based on a large collection of patterns that are learned from models manually designed by artists. The patterns are distilled into compact ...
The GUI tool automatically adds joinsbetween tables and allows working with INSERT, UPDATE, DELETE statements. More on building queries visually Database Designer Use database diagram for ...
- **Toad and Oracle Enterprise Manager**：介绍了Toad如何与Oracle Enterprise Manager集成，以便于更好地管理和监控Oracle环境。 #### 三、快速搜索与资源 - **Quick Search Bar**：通过快速搜索栏可以快速定位...
and c.owner = cc.owner and c.constraint_name = cc.constraint_name order by cc.position; 5、删除主键或外键 alter table TABLE_NAME drop constraint KEY_NAME; 6、建外键 单字段时：create table 表名...
Oracle.Data.Access.Components.v6.80.0.47.FS.forD5-D2009 Oracle Data Access Components Source Code ... All Rights Reserved ...There are two ways to compile and install ODAC for Windows manually.
- Oracle Database 12c - Xmanager Enterprise 3 - SecureCRT - rlwrap - Yum源配置 #### 第一章：软件下载与准备 1. **CentOS下载**： - 地址：[http://www.centos.org](http://www.centos.org) - 推荐...
Si5351是一款高度灵活且可配置的时钟发生器和电压控制晶体振荡器（VCXO），具备广泛应用和配置的特性，其配置软件ClockBuilder Desktop可以自动和便捷地为特定配置生成寄存器映射图。然而，在某些系统中可能不完全...
In this thesis, the design and implementation of an online answer system for programming classes based on the SSM (Spring, SpringMVC, MyBatis) framework and MySQL database will be discussed....
标题《zabbix部署文档》表明本文档是关于如何部署和配置zabbix监控系统的详细说明。zabbix是一个基于web的开源监控工具，用于监控各种网络服务、服务器和网络硬件的状态，以及收集、分析和呈现各种系统资源数据。...
When you use the sqlite3 module, the database connection details are slightly different from the ones you would use to connect to other database systems like MySQL, Post‐ greSQL, and Oracle....
A question we often see is "I have a lot of blank lines in my file and I don't want to go through and manually delete them. Is there an easier way to do this?" The answer is: yes! Configure FTP Set up...