Table of Oracle database recovery to be deleted-CodePudding

Oracle database truncate a table, can recover? How to restore? What is the easy way?
If it's the delete or drop a table, and how to restore?

CodePudding user response:

refer to the building of six seconds response:

truncate a Oracle database table, can recover? How to restore? What is the easy way?
If it's the delete or drop a table, and how to restore?

1, truncate the, more troublesome, recycling bins: no, not flashback, logminer also not line, can only hope the library open flashback or backup, but the whole database flashback and backup recovery cost is higher, generally all library falshback also won't open, but if you don't just truncate, can try this method below:
https://blog.csdn.net/tchic/article/details/52512473

2, can use the delete flashback, drop can use the recycle bin,

CodePudding user response:

1. Truncate the find similar odu tools, under the baidu
2. Delete can consider flashback, the premise is found undo_retention appropriately time processing, undo is not covered,
3. The drop in addition to similar odu tools, can also recycle bin, the premise is to open the function of the recycle bin,

CodePudding user response:

Truncate this may only be traversed by incomplete recovery processing, delete opened a flashback conditions can have a try, drop the recycle bin under the condition of meeting!