Oracle remove and place (re-install) database on 10g

oracleoracle-10g

I need to put together a plan to execute some change scripts to a Oracle 10g database, which will add some values, change some values a drop a table and create a new table.

I have a step for creating a DMP of the original database before the changes and for running a script that will execute all the changes.
But I need a back-out plan if things go wrong.
I was wondering what is the bets step(s) to drop the database and import the old DMP file?

I know about the sqlplus command:

imp <touser>/<password>@<host_address>/<service> file=<filename>.dmp fromuser=<fromuser> touser=<touser> log=backup_import.log

But what is the best way to drop the existing database? Is it just 

drop user <schema_user> cascade;

Thanks in advance.

K

Best Answer

The best way to drop database is to use DBCA graphic tool. Or you can use this sequence of commands:

shutdown immediate 
startup exclusive mount
alter system enable restricted session;
drop database;

But instead I suggest using RMAN backup and restore.

Related Question