Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Flashback Database / Schema

Thomas Minne-OracleJun 11 2009 — edited Jun 12 2009
Hello all,

Suppose that we have a big schema in a Database. I want to flashback the whole schema only.
My idea is to :

1) Disabling constraint (Foreign keys)
2) Flashback all the tables of the schema : one at a time.
3) Re enabling constraint

Does it make sense to you ?

Thanks
This post has been answered by Uwehesse-Oracle on Jun 12 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2009
Added on Jun 11 2009
#general-database-discussions
5 comments
1,510 views