Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete a datafile from a tablespace
Hanne Iren Midttun <hannem_at_tihlde.org> wrote in message news:<Pine.LNX.4.21.0306240857470.31693-100000_at_colargol.tihlde.org>...
> Hi,
> I have by accident added a datafile to the wrong tablespace. Can
> somebody tip me on how can I delete it again?
>
> (Never - ever start working before 1 cup of coffee :-)
>
> Hanne
An offline drop of the datafile should do it.
alter datafile '/u01/oradata/myfile' offline drop
It will be nice to take the necessary precautions though.
Export all tables in the tablespace,backup, full export ....
HTH
Michael Tubuo Ngong
Received on Tue Jun 24 2003 - 06:30:10 CDT