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
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.