Who dropped the table in teradata?

Database

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

2 REPLIES
N/A

Re: Who dropped the table in teradata?

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 :-)

Re: Who dropped the table in teradata?

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


Abhishek Jadhav