Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I move datafiles?
Hi Terry,
There is a small correction in Sajnish's Step#2. Instead COPY, you have to MOVE the data file to the target location. If you copy, the old version of the datafile will be still there in the previous location. I mean, we are duplicating that file. So that, remove the copied version, and move the original file to the new directory. Then give it a try.
Sarava Kunj (skunj_at_fresno.ca.gov)
In article <80ung7$gll$1_at_ezekiel.eunet.ie>,
"Terry" <tmaguire_at_iiu.nospam.ie> wrote:
> Sajnish
>
> 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
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Nov 17 1999 - 19:38:33 CST