Skip to Main Content

SQL & PL/SQL

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!

Trace the Delete and Drop statements ran from last week !

S567Apr 2 2020 — edited Apr 2 2020

HI Team,

I work  in Oracle database in 11g version.

Is there a way that i can trace my statements which  i ran in last week,

Actually i ran one delete statement in last week and deleted one record when i deleted i commited the statement too.

Now when i see today that record is still in DB.

I want to confirm whether it is a new entry or was it not deleted perfeclty ? Does th delete statements ran in past can also show how many records was it deleted ? Is there a way to find out.

Your assistance in this regard is highly helpful.

Thanks,

Shva.

Comments
Post Details
Added on Apr 2 2020
5 comments
1,654 views