Drop the database in oracle

Drop the database in oracle

STEP 1:  Shutdown the database

SHUT IMMEDIATE

STEP 2:  mount database

STARTUP MOUNT or STARTUP MOUNT RESTRICTED; or STARTUP MOUNT RESTRICTED EXCLUSIVE;

STEP 3:  Restrict the session

ALTER SYSTEM ENABLE RESTRICTED SESSION

STEP 4:  Drop the database

DROP DATABASE;

  • September 14, 2015 | 12 views
  • Comments