Oracle remove and place (re-install) database on 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 &lt;touser&gt;/&lt;password&gt;@&lt;host_address&gt;/&lt;service&gt; file=&lt;filename&gt;.dmp fromuser=&lt;fromuser&gt; touser=&lt;touser&gt; log=backup_import.log


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

drop user &lt;schema_user&gt; cascade;


Thanks in advance.

K
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.