Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Removing Datafiles.

Re: Removing Datafiles.

From: Em Pradhan <empradhan_at_dplus.net>
Date: Fri, 15 Jan 1999 22:48:09 -0500
Message-ID: <36A00BF8.6408A9C6@dplus.net>


Hi

    If you do not need that tablespace then

        just drop the tablespace with including contents option

then remove the file from operating system using os command in your system

good luck.

pradhan

mark trudelle wrote:

> I created a datafile to a TableSpace that I no longer need. Is there a way
> to remove this datafile from database. I'm operating in the following
> environment:
>
> * Oracle ver 7.3.3
> * HP UNIX VER 10
>
> Please send resonses to: kurt_at_totalnetnh.net
Received on Fri Jan 15 1999 - 21:48:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US