TimesTen Error Messages

TT-02783

Alter table to set new pages value is valid only if the table has a hash index on the primary key


Cause

You issued an ALTER TABLE...SET PAGES statement to possibly resize the hash index of a primary key, but there is no defined hash index for the primary key of the table.


Action

Run the ttIsql indexes command on the table to check the indexes defined on the table. ALTER TABLE...SET PAGES is used to resize an already defined primary key hash index. For more information, see ALTER TABLE in Oracle TimesTen In-Memory Database SQL Reference.


Additional Information

TimesTen did not perform the ALTER operation.