Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How can I drop a database?
Hi,
I just install for the first time an Oracle rdbms on a HP-UX server.
Unfortunately, when asking to give the database file location, i write out
/u02/oradata/UVISTEST instead of /u02. So now the files like control?.ctl,
redo0?.log and *.dbf are under the repertory
/u02/oradata/UVISTEST/oradata/UVISTEST. It's why I would like to drop the
database UVISTEST and recreate it in the proper repertory.
The question is: how to do to drop a database and recreate it under Oracle.
Loc Tran Received on Mon Oct 27 2003 - 12:01:36 CST