So far as I'm aware, table truncations aren't logged anywhere unless you're doing some sort of auditing.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: Thoka, Radhakrishna (GE Transportation, non-ge) [mailto:radhakrishna.[Email Address Removed]
Sent: Tuesday, March 30, 2004 11:29 PM
To: LazyDBA.com Discussion
Subject: Need a view!!!
Hi
Which view gives information about truncated tables in the database?
Thanks for ur information
Regards
Radhakrishna
Oracle LazyDBA home page