Answer Posted / Satish Chandra
To drop an Oracle database, you must first shut it down using the SQL*Plus command `SHUTDOWN IMMEDIATE`, then connect as SYSDBA (sysasm owner) and use the `DROP DATABASE` command.n```sqlnSQL> STARTUP MOUNT;
SQL> ALTER DATABASE OPEN READ ONLY;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP NOMOUNT;
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/your/destination';
SQL> CREATE DATABASE datafile1, datafile2, ...;
SQL> ALTER SYSTEM ARCHIVE LOG TRUNCATE;
SQL> ALTER SYSTEM SWITCH LOG FILE;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP NOMOUNT EXCLUSIVE;
SQL> DROP DATABASE;```
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
