Yinka's method will work and the ONLY possible fgall out will be a user that
attempts to use data currenly in that datafile...but the remainder of users
will be unaffected and tablespace will stay online and available

How big is this tablespace with 88 datafiles....




----- Original Message -----
From: "Olayinka Johnny [ MTN - OJOTA ] "
<oracledba-ezmlmshield-x62093853.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, November 02, 2006 4:47 AM
Subject: RE: Moving a Datafile


>
> 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
>
>
>
>
> ---------------------------------------------------------------------
> 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
>
>


Oracle LazyDBA home page