DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, September 14, 2015

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;

No comments: