RENAMING DATAFILE
693241May 20 2009 — edited May 20 2009Hello All,
We use Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit on Solaris 10.
I ran out of space in one of the mount points and when i checked al the files were oracle datafiles.
so i thought of moving datafile and rename it.
This is the steps i followed and the error thrown....
1)shutdown the database
2)cp /u02/oradata/DWH/temp01.dbf /u01/oradata/DWH/temp01.dbf
3)startup nomount
4)alter database mount
5)alter database rename file '/u02/oradata/DWH/users01.dbf' to '/u01/oradata/DWH/temp01.dbf';
Database altered.
6)alter database open;
alter database open
*
ERROR at line 1:
ORA-01122: database file 4 failed verification check
ORA-01110: data file 4: '/u01/oradata/DWH/temp01.dbf'
ORA-01251: Unknown File Header Version read for file number 4
Where am i doing the mistake....
Thanks in advance
Vijay G