Flashback data with "Flashback Query"?
Hi,
I have a question about FLASHBACK QUERY. In Oracle's website, it is written like below
(http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm):
The Flashback Query mechanism is flexible enough to be used in many situations. You can:
I think that " recover deleted or changed data " item means that we can recover only the records in a table through FLASHBACK QUERY, is that right? We cannot recover the DDL changes with it, instead, we need to use FLASHBACK DATABASE for this purpose, can you please confirm that?
I have a question about FLASHBACK QUERY. In Oracle's website, it is written like below
(http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm):
The Flashback Query mechanism is flexible enough to be used in many situations. You can:
- query data as it existed in the past.
- compare current data with past data. You can compare individual rows or do more complex comparisons such as finding the intersection or union.
- recover deleted or changed data.
I think that " recover deleted or changed data " item means that we can recover only the records in a table through FLASHBACK QUERY, is that right? We cannot recover the DDL changes with it, instead, we need to use FLASHBACK DATABASE for this purpose, can you please confirm that?
0