Re: How to drop Datafile from Tablespace?

Hi

    if you are testing then add datafile/s as you wanted and then drop tablespace. with out dropping tablespace U cannot remove the datafile. to remove datafile/s use your operating system command.
good luck
pradhan

Adrian Harrison wrote:

> Had to add several datafiles to an existing Tablespace for testing reasons!
>
> Can't find how to remove them! - I don't want to have to drop the tablespace itself!
>
> Any ideas
>
> Thanks
>
> A.H
Received on Wed Jan 20 1999 - 07:24:11 CST