Thank you all. I just resized the file. Can I change the name of the
datafile. I am unable to alter it. Any tricks.

TIA,
Laxmi.
----- Original Message -----
From: "Michael Porter" <[Email Address Removed] <[Email Address Removed] <[Email Address Removed] Monday, December 30, 2002 1:20 PM
Subject: Re: datafile file created in wrong tablespace - any remedy


> 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