Aviso importante
Caso tenhas alguma
dúvida a respeito
da linguagem mande
um e-mail que terás
a resposta.
C. A. Dornelles
SQL - SQLCODE's - Códigos positivos
Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF.
SQLCode +653
TABLE
table-name
IN PARTITIONED TABLESPACE
tspace-name
IS NOT AVAILABLE BECAUSE ITS PARTITIONED INDEX HAS NOT BEENCREATED
Causa
An attempt has been made to insert or manipulate data in or create a view on a partitioned table (that is, a table residing in a partitioned table space) before the partitioned index for that table has been created.
A table residing in a partitioned table space cannot be referenced in any SQL manipulative statement or a CREATE VIEW statement before the partitioned index for that table has been created.
Ação do sistema
A valid plan or package will be created if no errors are detected. The statement is bound dynamically on each execution of the statement.
Resposta ao Desenvolvedor
For better performance, rebind the plan or package after correcting the statement. To correct the statement, verify that the correct table was specified in the statement. If so, ensure that the partitioned index for the table has been created successfully before attempting to execute any SQL manipulative statements that reference that table.
SQLSTATE: 01551
