Teradata Database Message 8295 - 8295 - Analytics Database - Teradata Vantage

Analytics Database Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
15.xx,16.xx,17.xx
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-01-05
dita:mapPath
sfx1628096178347.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-1096
lifecycle
latest
Product Category
Teradata Vantageā„¢
Message
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
Notes
None
Remedy
The user must use DROP INDEX followed by CREATE INDEX to rebuild the NUSI and USI indexes.