Hi,
on 10g R2 on windows, I have lost user.dbf file and I have no back up. Then I want to recreate a new ansd recover. My steps are :
1-alter tablespace users offline temporary;
2-alter database create datafile 'C:\ORACLE\ORADATA\ORCL\USERS01.DBF';
3-RECOVER TABLESPACE USERS;
4-alter tablespace users online;
But when creating I have the following error :
SQL> alter database create datafile 'C:\ORACLE\ORADATA\ORCL\USERS01.DBF';
alter database create datafile 'C:\ORACLE\ORADATA\ORCL\USERS01.DBF'
*
ERROR at line 1:
ORA-01178: file 4 created before last CREATE CONTROLFILE, cannot recreate
Any idea ? Any help ? Thank you.