-- take the tablespace off line where these files resides
--Move or Copy to new device
--alter tablespace rename datafile 'old path' to 'newpath'
--recover datafile 'newpath'
--bring datafile online
--bring tablespace online
--delete oldfile(fr.old loaction)

HP
DBA

> -----Original Message-----
> From: sudhakar garlanka [mailto:[Email Address Removed] Sent: Thursday, August 30, 2001 3:29 PM
> To: LazyDBA.com Discussion
> Subject: Can I move datafiles from UFS onto a Unix raw device
>
>
> Hi,
>
> I have 3 datafiles (xxx.dbf) on a Unix file system. Now I
> got to relocate
> them to a new raw device. Is there a easy way I can do that
> other than
> dropping and recreating the schema objects residing on those
> datafiles.
>
> thanks
> -SG
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To 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