Friday, February 1, 2013

8 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

8 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
  2. Technology is updated day to day
    Thanks for sharing the info, Salesforce is the best platform for all organizations to perform the multiple tasks at a time
    Best Salesforce online Training
    Salesforce Online Training in Bangalore
    Salesforce certification Training program

    ReplyDelete
  3. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    Salesforce certification training

    ReplyDelete

  4. Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear.i also want to inform you the salesforce training online . thankyou . keep sharing..

    ReplyDelete
  5. Your style is very unique compared to other folks I've read stuff from. Many thanks for posting when you have the opportunity, blog Guess I will just book mark this site.
    Selenium Training in chennai | Selenium Training in anna nagar | Selenium Training in omr | Selenium Training in porur | Selenium Training in tambaram | Selenium Training in velachery

    ReplyDelete

 

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