Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

By mistake I have defined a property in Hibernate

<prop key="hibernate.hbm2ddl.auto">create</prop>

and I lost all the data I have in Oracle 10. Is there any way to rollback that transaction or recover that data?

share|improve this question

migrated from stackoverflow.com Feb 6 '10 at 13:58

This question came from our site for professional and enthusiast programmers.

    
What!? Maybe you should title this question "How to recover my data after....." Also, we can't give a specific answer unless you give a specific question. –  devnull Feb 6 '10 at 11:52
add comment

3 Answers

Do you mean:

hibernate.hbm2ddl.auto=create

If this is the case, i hope you have a backup then. Sorry.

share|improve this answer
add comment

If you have flashback enabled and your window is big enough you could get it back that way.

share|improve this answer
add comment

You'll need to do a point in time restore of the full backup and the log backups to the point in time just before you deleted the data.

If you don't have a backup you are out of luck.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.