Database Administration (MOSC)

MOSC Banner

Delete ILM on Table...what syntax?

edited Sep 3, 2015 10:07AM in Database Administration (MOSC) 1 commentAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center