Automating partition creation through plsql
Hi All,
i'm looking to add partition through plsql job for the entire year in , i'm not sure to dynamically pass these variables to be able to execute them one by one,
That start like this,
ALTER TABLE schemaname.tablename ADD PARTITION YR16_P1 VALUES LESS THAN (2016, 2)
and ends with ,
ALTER TABLE schemaname.tablename ADD PARTITION YR16_P12 VALUES LESS THAN (2017, 1)
How can i extract and assign variable to loop and create this , please give some pointers.
Thanks!