ARC0011 Too many objects to process on one statement

Archive/Recovery (ARC Prefix) Messages

brand
Teradata Tools and Utilities
prodname
Teradata Tools and Utilities
vrm_release
15.10
category
Programming Reference
featnum
B035-1096-151K

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.