Symptom
There exists a table placement setting for a table group, it is unwanted now and need to remove/unset it from placement setting.
e.g.
There is a created 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 need 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
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.
SAP Knowledge Base Article - Preview