Thursday, October 18, 2012

How to drop a Database

Hi ,
Please find the below steps.


HOW TO DROP DATABASE
===============================================
STEP1:  Shutdown the database immediately
SHUT IMMEDIATE
STEP2:  mount database
STARTUP MOUNT
STEP3:  Restrict the session
ALTER SYSTEM ENABLE RESTRICTED SESSION
STEP4:  Drop the database
DROP DATABASE;



======================================================
How TO DEINSTALL THE ORACLE SOFTWARE
======================================================
STEP1:  Goto ORACLE HOME directory
cd $ORACLE_HOME
Step 2: check the deinstall folder is there or not
cd deinstall
Step 3: Run the command
$./deinstall

No comments:

Post a Comment

Share your knowledge it really improves, don't show off...