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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I move datafiles?

Re: How do I move datafiles?

From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Thu, 18 Nov 1999 10:34:44 -0700
Message-ID: <383437fe_3@news.cadvision.com>


Sounds like
a) you don't have privileges for the file or directory b) misspelled the filename

You have the database mounted and not open?

--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

Terry wrote in message <80uni5$gmn$1_at_ezekiel.eunet.ie>...
>
>Terry
>
>I tried your steps and get the following errors
>
>
>ORA-01525: error in renaming data files
>ORA-01141: error renaming data file 2 - new file
>'h:\orant\database\usr1orcl.ora' not found
>ORA-01110: data file 2: 'D:\ORANT\DATABASE\USR1ORCL.ORA'
>ORA-09202: sfifi: error identifying file
>OSD-04002: unable to open file
>O/S-Error: (OS 5) Access is denied.
>
>BTW, I'm using Oracle 7.3.3 running on NT. The 'H:' disk is a server disk.
I
>have full access rights to this. And yes I did copy the file over!
>
>
>Regards
>
>Terry
>
>
>
>
>
>
>
>
>
>
>
Received on Thu Nov 18 1999 - 11:34:44 CST

Original text of this message

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