Teradata Database Message 9884 - 9884 - Analytics Database - Teradata Vantage

Message

Cannot add load isolation property for table with %VSTR defined on the table.

Explanation

An ALTER TABLE command is issued to alter the specified table to be a LDI table. The command cannot be executed successfully if: 1) If the table has NUSI or USI defined 2) If the table has one or more join indexes that are already not marked as load isolated tables. For example a single table join index exists on the table being altered. 3) If the table has column partitions defined on it.

Generated By

Resolver modules.

For Whom

End user.

Notes

None

Remedy

If the table is a column partitioned table, then alter table cannot be used to make the table a LDI table. Otherwise, drop the index or indexes and re-issue the command.