8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Flashback Data Archive (FDA) Enhancements in Oracle Database 12c Release 1 (12.1)


Jeroen said...

And again a big thanks for your introduction & explanation. A big help as usual!

Andy Campbell said...

Hi, Tim can you review your section on "Export/Import Table History" The DBMS_FLASHBACK_ARCHIVE.create_temp_history_table procedure only creates a temporary table, and doesn't populate it.

There is no current way it seems to export the the undo history to the temporary table.

Tim... said...

Hi.

Sorry. I missed out a step. The procedure just builds the correct shape table, but you have to populate it yourself. I've corrected the section to show how you do that.

Cheers

Tim...

Maksym said...

I can reccommend to read
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9531914100346195699
before using User-Context Tracking

Tim... said...

Hi.

Nothing surprising here.

- Audit takes space. You need to manage space.
- Doing a shutdown abort can cause issues if changes to settings have not already been written to disk.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.