Re: dropping a datafile

From: Vince Laurent <eAddict_at_yahoo.com>
Date: Tue, 28 Jan 2003 12:41:51 -0600
Message-ID: <jmjd3vorcfc0l8kh8mgm08718l01clknma@4ax.com>

But how does one remove them from oracle?

On Tue, 28 Jan 2003 17:29:55 GMT, "Brian E Dick" <bdick_at_cox.net> wrote:

>Once they are gone from Oracle, you can delete them with your favorite OS
>command.
>
>"Vince Laurent" <eAddict_at_yahoo.com> wrote in message
>news:9ded3v4ajn3k5lil868tj7v6pt4jdtqaic_at_4ax.com...
>> On our SAP system, we have a few tablespaces that are made up of MANY
>> datafiles. I have managed (via a 3rd party tool) to reorganize the
>> largest tables into thier own tablespacs. Now the original tablespace
>> is sitting very empty BUT the physical datafiles are still there. Is
>> there a way to drop them?
>> p.s We are running Oracle 8.1.7.3 on HP-UX 11.0
Received on Tue Jan 28 2003 - 12:41:51 CST