Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: delete database file on server -> sharing violation
On Oct 20, 9:06 am, "Greg D. Moore \(Strider\)"
<mooregr_deletet..._at_greenms.com> wrote:
> <sybra..._at_hccnet.nl> wrote in message
>
> news:n73kh3tkv0mv1ojudea4nskfd1amodq4dl_at_4ax.com...
>
> > On Sat, 20 Oct 2007 00:41:04 -0400, "Greg D. Moore \(Strider\)"
> > <mooregr_deletet..._at_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.htmlReceived on Mon Oct 22 2007 - 13:34:48 CDT