Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I drop a database?
Hi
Unless I am missing something, the simple answer to this is to run up the database configuration assistant (dbca on unix) and select "Delete Database" then choose the database from the list. Job done. Same tool to create a new database.
Though as Howard suggests, if you fancy a bit of on the job training then have a go at moving things around.
KJP
Loc Tran wrote:
> 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 - 19:49:57 CST