SAP Knowledge Base Article - Preview

3300317 - How to remove/unset a table placement setting for table group

Symptom

You have created a table placement setting for a table group, it is unwanted now and you want to remove/unset it from placement setting.

e.g.

You have create an object-specific rule for table placement for a DataStore object named DSOCORP, refer to the attachment file <DataStore objects type corporate memory on coordinator node.sql> of Note 2334091

And now you want to remove/unset it.

ALTER SYSTEM ALTER TABLE PLACEMENT (SCHEMA_NAME => '$$PLACEHOLDER', GROUP_TYPE => 'sap.bw.dso', GROUP_NAME => 'DSOCORP')
SET (LOCATION => 'master', MIN_ROWS_FOR_PARTITIONING => 50000000, INITIAL_PARTITIONS => 1, REPARTITIONING_THRESHOLD => 50000000, DYNAMIC_RANGE_THRESHOLD => 100000000, SAME_PARTITION_COUNT => 'TRUE');


Read more...

Environment

  • SAP HANA, platform edition 1.0
  • SAP HANA, platform edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

remove, unset, table placement, setting, table group, GROUP_NAME,  GROUP_TYPE  , KBA , HAN-DB-PER , SAP HANA Database Persistence , HAN-DB , SAP HANA Database , HAN-DB-ENG-BW , SAP HANA BW Engine , 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.