2

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?

splattne
  • 28,508
  • 20
  • 98
  • 148
  • 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. – bdd Feb 06 '10 at 11:52

3 Answers3

3

Do you mean:

hibernate.hbm2ddl.auto=create

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

Willi Schönborn
  • 141
  • 4
0

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

DCookie
  • 2,098
  • 1
  • 17
  • 18
0

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.

mrdenny
  • 27,174
  • 4
  • 41
  • 69