如何进行Oracle 删库，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。
站在用户的角度思考问题，与客户深入沟通，找到河北网站设计与河北网站推广的解决方案，凭借多年的经验，让设计与互联网技术结合，创造个性化、用户体验好的作品，建站类型包括：
网站建设、网站制作、企业官网、英文网站、手机端网站、网站推广、
主机域名、
虚拟主机、企业邮箱。业务覆盖河北地区。
今天就教你如何进行Oracle 删库！
DBCA启动图形界面
选择要删除的DB，点击finish按钮即可。
半杯茶的工夫，删库完成！比安装EZ很多~~
附1. 手工创建的数据库注册到DBCA（添加到最后一行）：
[oracle@db01 ~]$ vi /etc/oratab
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME::
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
ORCL:/u01/app/oracle/product/11.2.0/db_1:N
PROD:/u01/app/oracle/product/11.2.0/db_1:N
附2. DBCA静默安装的样例：
点击(此处)折叠或打开
[oracle@db01 ~]$ dbca -silent -createDatabase -templateName $ORACLE_HOME/assistants/dbca/templates/General_Purpose.dbc -gdbname PROD -sid PROD -characterSet ZHS16GBK
Enter SYS user password:
Enter SYSTEM user password:
Copying database files
1% complete
3% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/PROD/PROD.log" for further details.
看完上述内容是否对您有帮助呢？如果还想对相关知识有进一步的了解或阅读更多相关文章，请关注创新互联-成都网站建设公司行业资讯频道，感谢您对创新互联的支持。
网页标题：如何进行Oracle删库-创新互联
文章网址：
http://cdkjz.cn/article/ghjdg.html
