up vote 2 down vote favorite
share [g+] share [fb]

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?

link|improve this question
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. – Paperino Feb 6 '10 at 11:52
You're in the lap of the gods. Try serverfault.com. – skaffman Feb 6 '10 at 13:52
feedback

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

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

3 Answers

up vote 3 down vote

Do you mean:

hibernate.hbm2ddl.auto=create

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

link|improve this answer
feedback
up vote 0 down vote

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

link|improve this answer
feedback
up vote 0 down vote

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard