Delete ILM on Table...what syntax?
Hello all,
maybe I am simple to stupid to write the right syntax ,but her my problem:
I want to delete ILM what shows me the DDL:
only part of DDL:
AFTER 3 DAYS OF CREATION; ALTER TABLE "EVO_DM"."F_CONTRACT_STOCK" MODIFY PARTITION "MSD_201408" ILM ADD POLICY COLUMN STORE COMPRESS FOR QUERY HIGH SEGMENT AFTER 3 DAYS OF CREATION; ALTER TABLE "EVO_DM"."F_CONTRACT_STOCK" MODIFY PARTITION "MSD_201409" ILM ADD POLICY COLUMN STORE COMPRESS FOR QUERY HIGH SEGMENT AFTER 3 DAYS OF CREATION; ALTER TABLE "EVO_DM"."F_CONTRACT_STOCK" MODIFY PARTITION "MSD_201410" ILM ADD POLICY COLUMN STORE COMPRESS FOR QUERY HIGH SEGMENT AFTER 3 DAYS OF CREATION;
0