Dear all,

I had space problem in my disc.So I manually shifted oradata folder (containing all control and dbf files) to a different location.

Then I created spfile after necessary changes.

But when I try to open the database , its showing error.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 790096 bytes
Variable Size 170914224 bytes
Database Buffers 440401920 bytes
Redo Buffers 262144 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'P:\ORACLE\PRODUCT\10.1.0\ORADATA\TCENG\SYSTEM01.DBF'

Is there any way to resolve it?
Any way I have to shift the dbf files.
Please help.