Duplicate rows in dbc.tablesize

Database

Duplicate rows in dbc.tablesize

Hello everybody.

I found out some duplicate rows in the view dbc.tablesize.

This rows have the same vproc, databasename and tablename but different currentperm.

Is there something odd, or I didn't understand that view's meaning ?

2 REPLIES
Teradata Employee

Re: Duplicate rows in dbc.tablesize

Since TD12.0 you should be using dictionary views with V suffix, e.g. DBC.TableSizeV. The backward-compatible views without the V truncate object names at 30 characters.

Fan

Re: Duplicate rows in dbc.tablesize

Hello Fred, Thank you for your Help.