TimesTen Error Messages

TT-05303

Create table statement generated is too long


Cause

The built-in procedure or command generated a CREATE TABLE statement that exceeds the maximum length for a SQL statement. The CREATE TABLE statement was generated by the ttTableSchemaFromOraQueryGet built-in, or the ttLoadFromOracle built-in, or the createAndLoadfromOraQuery command.


Action

Modify the Oracle database SQL statement to shorten the length of the generated CREATE TABLE statement and call the built-in procedure or command. For more information on system limits, see System Limits and Defaults in Oracle TimesTen In-Memory Database Reference.

For more information on the ttTableSchemaFromOraQueryGet and ttLoadFromOracle built-in procedures and createAndLoadfromQuery command, see ttTableSchemaFromOraQueryGet, ttLoadFromOracle, and ttIsql, respectively, in the Oracle TimesTen In-Memory Database Reference.


Additional Information

The generated CREATE TABLE statement cannot be executed.