Re: Moving datafiles

From: Stephen Andert <StephenAndert_at_firsthealth.com>
Date: Thu, 06 Jul 2000 08:50:12 -0600
Message-Id: <10550.111345@fatcity.com>

Don't forget to take the tablespace offline first!

Also, in your step 2, don't forget that the file name is in single quotes = (i.e. alter database rename file 'original_dir\datafile.dbf' to 'new_dir\datafile.dbf')

HTH Stephen Andert

>>> Kirsten.deWeerd_at_Oranjewoud.nl 07/06 2:44 AM >>>
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 :

on the OS : mv original_dir\datafile.dbf new_dir\datafile.dbf
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

--=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 - 09:50:12 CDT