resize the datafile to min, only option. then add another(new) to other tablespace

-----Original Message-----
From: Vijayalaxmi Balcha [mailto:[Email Address Removed] Monday, December 30, 2002 1:17 PM
To: LazyDBA.com Discussion
Subject: 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