RE: Moving datafiles

Yes. However or the database is down or you put the tablespace offline first.

Regards.

> -----Mensaje original-----
> De: Solis Llera, Eduardo [SMTP:esolis_at_mapfre.com]
> Enviado el: Jueves 6 de Julio de 2000 07:54
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE: Moving datafiles
>
> yes that is correct.
>
> > -----Mensaje original-----
> > De: Weerd de E.C. Kirsten [SMTP:Kirsten.deWeerd_at_oranjewoud.nl]
> > Enviado el: jueves 6 de julio de 2000 11:44
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: 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).
> --
> Author: Solis Llera, Eduardo
> INET: esolis_at_mapfre.com
>
> 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 - 07:11:04 CDT