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!

ORA-01178: file 4 created before last CREATE CONTROLFILE

happy10319Dec 7 2008 — edited Dec 7 2008
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.
This post has been answered by 653835 on Dec 7 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2009
Added on Dec 7 2008
1 comment
2,759 views