Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Drop Database but Keep SPFILE

AliDOct 31 2010 — edited Nov 1 2010
Hi,

Starting 10g, Oracle introduced the command DROP DATABASE. It drops data files, redo logs, controlfile and SPFILE.

However, I want to keep SPFILE; because I'm going to restore the database immediately after drop. One solution is to copy spfile somewhere and copy it back to original location after each drop. Another is to use PFILE instead.

None of these really suits my situation. Do you guys know of any other workaround to run from RMAN or SQLPLUS?

Thanks,
Ali
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2010
Added on Oct 31 2010
7 comments
1,166 views