15.00 - 5467 Cannot drop, MLOAD, or RESTORE a table with join or hash indexes. - 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)

5467 Cannot drop, MLOAD, or RESTORE a table with join or hash indexes.

Explanation:

Cannot perform drop, MLOAD, or RESTORE on a table when a join or hash index exists on that table OR a temporal table with a system-defined join index is being renamed.

Generated By:

Oph modules (OphEdUpd, OphEdDel, OphEdUpd, OpdDropT, ophrstdb)

For Whom:

End User.

Remedy:

Drop the Join or Hash Index Table first before performing drop, MLOAD, or RESTORE on the table.