Skip to Main Content
  • Questions
  • Monitoring TRUNCAT TABLE - WHEN and WHAT SESSION ?

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Hanumantha Rao.

Asked: March 11, 2018 - 3:59 am UTC

Last updated: March 11, 2018 - 11:29 am UTC

Version: 12.1.0.2.0

Viewed 1000+ times

You Asked

Hi

We are facing some strange issues in our test environments where TRUNCATE table was happening and we could NOT find when it was truncated and what session is causing it ?

Is there any way to monitor the truncate ? Such as Who ? When ? Session info.


Thanks,
Hanu

with LiveSQL Test Case:

and Connor said...


Is this answer out of date? If it is, please let us know via a Comment

More to Explore

SQL

The Oracle documentation contains a complete SQL reference.