shutdown db
COPY datafile to the new name.
startup mount
alter database rename data file '....' to '.....';

alter database open;

>>> "Vijayalaxmi Balcha" <[Email Address Removed] 12/30/02 01:23PM
>>>
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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page