SAP Knowledge Base Article - Preview

2738610 - How to truncate or delete rows from sys.table_placement - SAP HANA

Symptom

  • SAP Note 1986612 is being followed to remove additional indexservers.
  • How to truncate or delete rows from sys.table_placement table?
  • When doing truncate or delete, it reports:

Could not execute 'truncate table SYS.TABLE_PLACEMENT'
SAP DBTech JDBC: [259]: invalid table name: TABLE_PLACEMENT: line 1 col 20 (at pos 19)

Could not execute 'delete from "SYS"."TABLE_PLACEMENT"'
SAP DBTech JDBC: [361]: data manipulation operation not legal on this view


Read more...

Environment

SAP HANA

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB , SAP HANA Database , How To

About this page

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

Search for additional results

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