Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> AW: Moving datafiles

AW: Moving datafiles

From: Libal, Ivo <ivo.libal_at_knapp-systems.com>
Date: Thu, 6 Jul 2000 12:41:49 +0200
Message-Id: <10550.111320@fatcity.com>


the datafile must be offline

> -----Urspr=FCngliche Nachricht-----
> Von: Weerd de E.C. Kirsten [SMTP:Kirsten.deWeerd_at_Oranjewoud.nl]
> Gesendet am: Donnerstag, 6. Juli 2000 11:44
> An: Multiple recipients of list ORACLE-L
> Betreff: Moving datafiles

>=20

> Hi all,
>=20

> The simplest things sometimes keep confusing me, so I'll just ask
> and see if someone agress or not :-)
>=20

> I need to move some datafiles around on Hp-UX 10.20
>=20
> I figure I can do this in two steps :
>=20

> 1. on the OS : mv original_dir\datafile.dbf new_dir\datafile.dbf
>=20
> 2. in the DB : alter database rename file original_dir\datafile.dbf =
to
> new_dir\datafile.dbf
>=20

> Correct ???
>=20

> Greets,
>=20

> Kirsten
> Living near Antwerp, Belgium
> Working near Breda, Netherlands
>=20

> --=20
> Author: Weerd de E.C. Kirsten
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>=20

> 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:41:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US