how to identify "down" tables in all Teradata system

Database
Teradata Employee

how to identify "down" tables in all Teradata system

I have a problem to find "down" tables in entire Teradata system. Does it exist somethink like a "SELECT tablename FROM dbc.some_table WHERE something_like_down_attribute? Thank you for the advice

Jiri

2 REPLIES
Enthusiast

Re: how to identify "down" tables in all Teradata system

Hi Jiri,

Kindly do clarify what is a down table, so we would be able to help you out

Teradata Employee

Re: how to identify "down" tables in all Teradata system

ALTER TABLE **bleep** SET DOWN or ALTER TABLE **bleep** RESET DOWN

 

Jiri