15.00 - 6952 Indexes cannot be created or dropped during random AMP sample emulation. - 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)

6952 Indexes cannot be created or dropped during random AMP sample emulation.

Explanation:

When random AMP sample emulation is active for a table indexes cannot be created or dropped on that table.

Generated By:

OPT modules.

For Whom:

End User.

Remedy:

If you want to turn off random AMP sample emulation use the DIAGNOSTIC HELP SAMPLES to determine the samples that have been set and the DIAGNOSTIC SET SAMPLES statement to turn them off. If you want to emulate with the index change you must make the change on the target system and then re-extract the random AMP samples.