All Forums Database
17 May 2016
Who dropped the table in teradata?

Hi,
which table do we need to check, who dropped the table in Teradata?
we are facing this issue but unable to find in dbqlogtbl table.
Thanks,
Narasimha

dnoeth 4628 posts Joined 11/04
18 May 2016

I really don't know why, but dbc.EventsV usually has an entry 'Logging Online Archive Off' when a table is dropped and the submitting User is also included :-)

Dieter

abhishek.jadhav 28 posts Joined 02/08
23 May 2016

If the table has “online logging” enabled, we need to disable online logging when table is dropped.

But currently for most of the drop table statements Teradata submits a “LOGGING ONLINE ARCHIVE OFF” regardless if this table has been online logging enabled or not and hence you will see a “LOGGING ONLINE ARCHIVE OFF” row in RCEvent table for DROP TABLE statement. 

 

As per TD Engineering this is a known issue and will be fixed in future TD release.

 

 

- Abhishek Jadhav

Thanks
Abhishek Jadhav

You must sign in to leave a comment.