Hi Anil,

You don't have to take the entire tablespace offline. Follow the steps
below to get this sorted

1. Take a backup of the affected datafile

2. Take the affected datafile offline. E.g ALTER DATABASE DATAFILE
'/u07/oradata/PRD/ordtab03.dbf' OFFLINE;

3. Copy the datafile to the 'new mount point'.

4. Rename the datafile. E.g ALTER DATABASE
RENAME FILE '/u07/oradata/PRD/ordtab03.dbf'
To '/new_mount_point/../ordtab03.dbf'; This will rename
the file pointers in the database control file.

5. Bring the datafile online.
E.g ALTER DATABASE DATAFILE '/new_mount_point/../ordtab03.dbf' online;

I hope this help.

Cheers,

Yinka.

-----Original Message-----
From: Bommareddy Anil Kumar
[mailto:oracledba-ezmlmshield-x50179885.[Email address protected]
Sent: Thursday, November 02, 2006 10:27 AM
To: LazyDBA Discussion
Subject: Moving a Datafile

Hi Gurus,
Here's my problem :
1. System is 24*7*365. No down time allowed.
2. A new datafile is created in wrong mount point. And it is
already open.
3. How to move this datafile to another mount point without taking
the tablespace offline as it has another 88 datafiles online.


Thanks,
Anil


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


NOTE: This e-mail message is subject to the MTN Nigeria disclaimer see http://www.mtnonline.com/contact/disclaimer.asp



Oracle LazyDBA home page