Database Administration (MOSC)

MOSC Banner

Created Flashback Data Archive - How Archive Table entered the Data of rows affected at Original Tab

edited Aug 5, 2020 8:11AM in Database Administration (MOSC) 2 commentsAnswered ✓

Dear All,

In my machine Oracle Database Server  11.2.0.4  installed. I need to track deleted rows from almost All the Tables of my Database.

So I have made Flashback Data Archive for 1 Year and made enable Flashback Data Archive for some Tables.

then queried

"select archive_table_name from user_flashback_archive_tables where status='ENABLED'" to get each table's respected archive table name.

After i chose one table and deleted the row from that table.

And immediately i have queried its Archive Table. But no rows there. After some times i got 2 rows of into table in which One Row has Operation 'D'.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center