Hi,
Unfortunately, there is no way to remove or drop this file from the
tablespace. You will need to re-build the entire tablespace without this
file. You may consider to resize it to a bare minimum to release file system
space.
- Kirti
> -----Original Message-----
> From: Helmut Daiminger [SMTP:hdaiminger_at_vivonet.com]
> Sent: Wednesday, October 18, 2000 1:07 PM
> To: Oracle List (Telelist); Oracle DBA List (Lazy DBA)
> Subject: how to drop datafile
>
> Hi!
>
> I accidentally added a datafile to the wrong tablespace. How can I drop
> this
> datafile from that tablespace again?
>
> Thanks,
> Helmut
>
>
> --------
> Think you know someone who can answer the above question? Forward it to
> them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
Received on Wed Oct 18 2000 - 13:18:40 CDT
