Skip to Main Content

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 Time Travel - Sys Contexts in ADB-S

user2606280Jun 18 2024

We are using Flashback Time Travel (formally Flashback Data Archive) in ADB-S to track historic changes made within our APEX application. In Autonomous, how do we additionally store the Sys Context data (ie APEX APP_USER etc.) within Flashback?

In standard Oracle databases it is enabled by issuing the following, but this prevented in ADB-S:

exec dbms_flashback_archive.set_context_level('ALL');

Reference: https://insum.talan.com/use-flashback-data-archive-instead-of-journaling-tables/

Thanks

Comments
Post Details
Added on Jun 18 2024
2 comments
334 views