ALTER TABLE name SET ( RETAIN HISTORY = FOR retention_period )