Data Ageing - What to do, if Time Selection Partitioning goes wrong

[Former Member]

dear all

after creating a wrong partitioning spec in Data Ageing - Tx DAGPTC.

i found it impossible to immediately revert back to the state i had, prior to the mistake.

this is a test system, so no real damage done, however, in my attempts to find an answer/procedure, i found nothing, so if anyone can point me in a direct, i would be most grateful.

please dont just reference the administration guide.

what i am looking for, would be something like the syntax to merge a time partition, or undo a command, or something.

note: this problem has nothing to do with data aging runs, nor the undo functionality, as it is prior to any runs at all.

any help please

thanks

[BrigitteReinelt]

Hi Margaret,

there's no way via SAP Gui. However, with SAP HANA 2.0, there's an easier way with respect to the statements that you can use, as the functionality to merge data aging partitions (including down to 0 partitions) is included there.

Please refer to help.sap.com (link below). If the link does not work out as expected, search on the help portal for "HANA Platform" and in there for "partitioning". Choose the "SAP HANA Administration Guide for SAP HANA Platform". Chapter "Change a Partitioned Table into a Non-Partitioned Table", esp. sub-chapter "Time Selection Partitioning (Aging)" is what you are looking for.

https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.04/en-US/4810afe854254d46b947ef9cd4...

Hope this helps!

Warm regards,

Biggi.

[marge]

Thanks for the inputs Biggi.