ARC0011 Too many objects to process on one statement - Teradata Tools and Utilities

Archive/Recovery (ARC Prefix) Messages

Product
Teradata Tools and Utilities
Release Number
15.xx,16.xx
Language
English (United States)
Last Update
2018-10-23
dita:id
B035-1096-ARC
lifecycle
latest
Product Category
Teradata® Tools and Utilities

ARC0011 Too many objects to process on one statement

Explanation:

An archive and recovery statement was entered which, after excludes, had too many objects to process at one time.

For Whom:

End User.

Notes:

The archive and recovery software uses Teradata SQL to do some of its work. The maximum length of a Teradata SQL statement is 8192 characters which was exceeded for the set of objects.

Remedy:

Break the statement up and resubmit. The length of the Teradata SQL statement buffer is 256 plus overhead for objects. A database object requires 63 bytes and a table object requires 126 bytes. If the database object was an ALL one, then each database in the hierarchy must be accounted for.