RE: Moving datafiles

Just some points , though you may be aware

Step 0 - Bring down database beofre mv

Step 2 to be done in Startup mount Condition

> -----Original Message-----
> From: Weerd de E.C. Kirsten [SMTP:Kirsten.deWeerd_at_Oranjewoud.nl]
> Sent: Thursday, July 06, 2000 3:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Moving datafiles
>
> Hi all,
>
> The simplest things sometimes keep confusing me, so I'll just ask
> and see if someone agress or not :-)
>
> I need to move some datafiles around on Hp-UX 10.20
>
> I figure I can do this in two steps :
>
> 1. on the OS : mv original_dir\datafile.dbf new_dir\datafile.dbf
>
> 2. in the DB : alter database rename file original_dir\datafile.dbf to
> new_dir\datafile.dbf
>
> Correct ???
>
> Greets,
>
> Kirsten
> Living near Antwerp, Belgium
> Working near Breda, Netherlands
>
> --
> Author: Weerd de E.C. Kirsten
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Jul 06 2000 - 05:10:26 CDT