RE: Moving datafiles

Yes Its fine .
But shutdown your database normally,
then startup your database in mount stage and then follow the steps you have mentioned.
after this you will able to open your database. Confirm from dba_data_files that your data files are residing in new location.
Now you can remove the old location datafiles.

Vikas

-----Original Message-----
From: Weerd de E.C. Kirsten [mailto: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).