Re: How to remove a datafile from the tablespace?

From: Little Prince <milan1810_at_geocities.com>
Date: Wed, 18 Jul 2001 23:38:53 +0800
Message-ID: <9j4aj3$cfl3@ctmsun0.macau.ctm.net>

Try the following
1. Alter database datafile 'xxx.dbf' offline drop; 2. You may need to remove the datafile manually (I'm not sure. Try yourself)

Regards,
Andrew

"Ganesh Kamath" <ganesh.kamath_at_in.bosch.com> wrote in message news:9j33dk$pih$1_at_proxy.fe.internet.bosch.com...
> Hello,
>
> By mistake one datafile has been added to a tablespace, which already had
> one datafile. Now I want to delete the newly added datafile. How do I do
> this? I don't want to drop the tablespace.
>
> Thanks,
> Ganesh Kamath
>
>
Received on Wed Jul 18 2001 - 10:38:53 CDT