datafile file created in wrong tablespace - any remedy

datafile file created in wrong tablespace - any remedy

 

  

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