Posted by joel garry on 10/22/07 18:34

On Oct 20, 9:06 am, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@greenms.com> wrote:
> <sybra...@hccnet.nl> wrote in message
>
> news:n73kh3tkv0mv1ojudea4nskfd1amodq4dl@4ax.com...
>
> > On Sat, 20 Oct 2007 00:41:04 -0400, "Greg D. Moore \(Strider\)"
> > <mooregr_deletet...@greenms.com> wrote:
>
> >>However, I would suspect simply deleting the files would cause error
> >>messages to show up when Oracle was restarted or the system was restarted?
> >>Most likely this would be non-fatal but as I prefer to run w/o errors, I'm
> >>curious as to the "correct" way to remove a database on a Unix system.
>
> > Dbca: delete database.
>
> Thanks. I'll keep that in mind.

Is a database that you are talking about the same as the database that
Sybrand is talking about? It is pretty common for the Oracle
equivalent to an MS database to be a schema. So the correct way on a
unix system would be a "drop user" command, with other commands such
as "drop tablespace including contents and data files" for actually
removing files. But you really should know what you are doing.
Whether the datafile handles are kept open varies by configuration and
versions.

jg
--
@home.com is bogus.
http://bofh.ntk.net/StickyMags.html

[Back to original message]