Hi Anil,
is this possible to have the tablespace in read-only mode during the
transfer (which should take only few minutes) ?

Thanks
Aramas

> -----Message d'origine-----
> De: Bommareddy Anil Kumar
> [SMTP:oracledba-ezmlmshield-x50179885.[Email address protected]
> Date: jeudi 2 novembre 2006 10:27
> À: LazyDBA Discussion
> Objet: 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
>


----------------------------------------------------
Ce message et toutes les pieces jointes (ci-apres le "message") sont confidentiels et etablis a l'intention exclusive de ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite.Tout message electronique est susceptible d'alteration.
Le CREDIT DU NORD et ses filiales declinent toute responsabilite au titre de ce message s'il a ete altere, deforme ou falsifie.
This message and any attachments ( the "message") are confidential and intended solely for the addressees.
Any unauthorised use or dissemination is prohibited.E-mails are susceptible to alteration.
Neither CREDIT DU NORD nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified.
----------------------------------------------------


Oracle LazyDBA home page