15.00 - 8295 Restore stopped because block optimization is disabled. Unable to rebuild secondary indexes. Selected partition restore error table %DBID.%TVMID. - 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)

8295 Restore stopped because block optimization is disabled. Unable to rebuild secondary indexes. Selected partition restore error table %DBID.%TVMID.

Explanation:

Selected partition restore uses block optimization to restore NUSI and USI indexes. However this feature has been disabled by the user.

Generated By:

Hut build process for data tables.

For Whom:

End User

Remedy:

The user must use DROP INDEX followed by CREATE INDEX to rebuild the NUSI and USI indexes.