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-ENG , SAP HANA DB Engines , How To

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.