Re: How to remove a datafile from the tablespace?

In article <9j4aj3$cfl3_at_ctmsun0.macau.ctm.net>, "Little says...
>
>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)
>

Don't "try" things you don't understand!

If you do that, your only recourse is to drop the tablespace (explicitly state "i do not want to drop the tablespace")

fact is, once added, a file is part of a database until you drop the tablespace it is part of.

You can move it, you can resize it (shrink it way down) but you aren't going to get rid of it.

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:515222144417 for more info.

>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
>>
>>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp