June 19th, 2005, 04:34 AM
|
|
Contributing User
|
|
Join Date: Oct 2004
Posts: 46
Time spent in forums: 6 h 36 m 29 sec
Reputation Power: 4
|
|
Problem with renaming datafile
Hi all,
Scenario:
I want to move a recovered datafile from "C:\Windows\System32" to "%ORACLE_BASE%\oradata\myinstance".
I made the tablespace offline and move the file to destination in mounted state. Now I am trying to rename file using this command:
ALTER DATABASE RENAME FILE 'dest_path\old_name.dbf' TO 'dest_path\new_name.dbf';
It throws these errors:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile "E:\oracle\product\10.1.0\oradata\myinstance\old_name.dbf"
What is the problem?! I can see my datafile using OS but Oracle cant see it?
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
