SAP Knowledge Base Article - Preview

3518222 - Backup and Restore table having Primary Key - SAP IQ

Symptom

Currently there are limitations to restore a source table having Primary Key.

Table having Primary cannot be restored.
 

  • If the Primary key is dropped before restore, then restore fails with error

    Could not execute statement.
    The meta data of the table backup archive is incorrect. 

  • If target table is created with Primary Key as the source, then restore fails with error

    Could not execute statement
    Cannot restore table backup while secondary indexes are declared on it


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

sybase, 829845, CR829845, CR#829845 , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.