Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

Do you mean:

hibernate.hbm2ddl.auto=create

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

share|improve this answer

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

share|improve this answer

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

Your Answer

 
discard

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