Skip to Main Content

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!

Problem rename temp file

tad_csApr 16 2007 — edited Apr 16 2007
Hi all, I´m using oracle 9.2.0.4 and I ´m trying to do a rename of a temp
file, so I´ve tried to do this:
1- shutdown immediate;
2- move the file to new local;
3- startup mount;
4- alter database rename file
          '/oracle1/oradata/devdb/data/basic/tbs_temp_basic01.dbf'
      to '/oracle_1/oradata/devdb/data/basic/tbs_temp_basic01.dbf';
5- open.
but the following error occurs:
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile
"/oracle1/oradata/devdb/data/basic/tbs_temp_basic01.dbf"
I did not understand this error cause in the new local, the file exists.
So, I´ve tried to do a copy instead of move, but the error persists.

Somebody can help me?

thank U

[]´s
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2007
Added on Apr 16 2007
2 comments
3,360 views