Database Backup and Recovery (MOSC)

MOSC Banner

How to trackback deletion of records without flashback ?

edited Mar 14, 2013 6:41AM in Database Backup and Recovery (MOSC) 11 commentsAnswered
Hi There,

We are using 11g and we do not have flashback feature enabled.

I trying to investigate a deletion of records, need help as i am not able to tack deletion statements.

I have done following

1. Looking at logminer data ( it did not show any SQL which could cause mass deletion)

2. review All relavent Forms code / packages / procedure ( it did not show any statemet which can cause mass deletion)

3. Looking in dba_hist_sqltext and dba_hist_active_sess_history tables for any unusual sql => but sql_text is shown as bind variables and also did not show any sql which can do mass deletion.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center