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!

Delted USERS01.DBF, how get DB running again?

710419Jul 29 2009 — edited Jul 29 2009

Hi and my appreciation for reading,

I accidentally deleted my USERS01.DBF and with it all my data of the "admin" account.

Now I am trying to get things running again, but have some problems (I am aware I cant recover the data, and since it was a test db anyway I am not trying to).

I would like to create some tables, but get the following error on every attempt:

ORA-01658: Unable to create INITIAL extent for segment in tablespace %s

I already tried to change the tablespace but am getting the follwing error for that:

ORA-00376: file 4 can not be read at this time

Thanks a lot for you help

Evgeny

This post has been answered by Uwehesse-Oracle on Jul 29 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 26 2009

Added on Jul 29 2009

#general-database-discussions

6 comments

1,203 views