Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01516: nonexistent log file, datafile, or tempfile

happy10319Aug 10 2007 — edited Aug 11 2007

Hi,
in 10g R2 on Win XP when I do :

alter database rename file 'C:\oracle\oradata\ORCL\USERS01.DBF' to 'C:\oracle\oradata\ORCL2\USERS01.DBF';
I receive :

ORA-01511: fail to change name ...
ORA-01516: nonexistent log file, datafile, or tempfile
'C:\oracle\oradata\ORCL\USERS01.DBF'
But it realy exists.
Please help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2007

Added on Aug 10 2007

#general-database-discussions

9 comments

14,654 views