Teradata Database Message 5467 - 5467 - Analytics Database - Teradata Vantage

Message

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.

Notes

None

Remedy

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