15.00 - 5303 Error table '%VSTR' already exists. - Teradata Database

Teradata Database Messages

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

5303 Error table '%VSTR' already exists.

Explanation:

Teradata system creates an error table to store target data rows that violate the specified referential constraint when the constraint is added to an existing table via ALTER TABLE statement or an inconsistent referential constraint is revalidated via REVALIDATE REFERENCES statement. The name of the error table is the target table name appended by the corresponding reference index number. If a table with that name has already existed in the system, then this error is returned.

Generated By:

RES modules.

For Whom:

End User.

Remedy:

Drop the table in conflict, and resubmit request.