Once datafile is added, you can't delete from tablespace.
Options, reduce to small size and set autoextend off or
you'll have to go through the process of exporting/moving objects out off tablespace and recreating it.

Regards,
Afzal Chaudhry

----- Original Message -----
From: Vijayalaxmi Balcha <[Email Address Removed] Monday, December 30, 2002 10:16 am
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