Friday, February 1, 2013

1 Drop Oracle database with DBCA

We can use dbca to drop the database.

 

Use DBCA GUI

 

image

image

image

image

Select NO.

image

The database is being drop. The password file and parameter file are being removed too.  ( Both files are under $ORACLE_HOME/dbs).

image

Use DBCA command line

dbca -silent -deleteDatabase -sourceDB oracledb1 -sysDBAUserName sys -sysDBAPassword

 

image

Reference

http://www.sqlpanda.com/2012/12/oracle-database3-drop-database.html

1 comments:

  1. Oracle Database Training will help you develop a thorough understanding of Oracle Database, as well as its related products. With more than 50 Database offerings, enhance your knowledge of Database 11g, MySQL, Data Guard, and more.


    SQL Training Centers in Chennai
    Oracle Course in Chennai

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates