15.00 - Restrictions and Limitations for Error Tables - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Restrictions and Limitations for Error Tables

You can use the CREATE INDEX statement to add a secondary index to an error table (see “CREATE ERROR TABLE” on page 228) to facilitate scanning its captured data for analysis.

If you do this, you must then drop any of the secondary indexes you have defined before you perform an INSERT … SELECT or MERGE operation that specifies error logging on the data table associated with the error table.