Nope. All you can do is shrink as small as it will allow you to (alter
...resize) OR you have to back up the objects in that tablespace, drop
it and recreate...

Mike

>>> "Vijayalaxmi Balcha" <[Email Address Removed] 12/30/02 01:16PM
>>>
Hi all,

I added new datafile in wrong tablespace. Can I move that datafile to
the tablespace I want. If so what steps should I take. I tried to take
the datafile offline but it does't allow me from dbastudio.

TIA
Laxmi
Oracle LazyDBA home page