PL/SQL (MOSC)

MOSC Banner

Automating partition creation through plsql

edited Oct 28, 2016 5:03AM in PL/SQL (MOSC) 2 commentsAnswered ✓

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!

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