Thursday, November 23rd, 2017

Drop Data Base from oracle

0

Drop Data Base from oracle

DROP USER databasename cascade; //Oracle

It is possible to drop a database in Oracle with the new SQL statement drop database. The command gets rid of datafiles online redo log files, controlfiles and spfile.

Example to use the command

shutdown abort;
startup mount exclusive restrict;
drop database;
exit

Requirements

    database must be closed,
    exclusively mounted,
    restricted
Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • LinkedIn
  • RSS
  • Technorati
  • Twitter

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

Secure Linux Web Hosting