Re: Dropping a datafile

From: Eugene Firyago <efiryago_at_bisys.com>
Date: 2000/01/30
Message-ID: <872a2m$mvb$1@bob.news.rcn.net>#1/1

You can physically remove a datafile with RECOVER status since you never really going to recover it in the future.

Neil Carter <ncarter_at_nilfisk-advance.com> wrote in message news:3891F2ED.5B6A662_at_nilfisk-advance.com...
> Greetings:
>
> Running 7.3.4 on AIX. We added some very temporary files in the 'Temp'
> tablespace and now would like to remove them. Taking them off-line put
> them into 'Recover' status.
>
> Again, we just want to drop some datafiles from the tablespace,
> preferably with the database open, that are already off-line.
>
> Any assistance is greatly appreciated!
>
Received on Sun Jan 30 2000 - 00:00:00 CST