Linux Operating System (MOSC)

MOSC Banner

need help on shell scripting

edited Feb 23, 2015 6:49AM in Linux Operating System (MOSC) 4 commentsAnswered

Hi All,

I'm trying schedule bash shell script that would dynamically gather partition stats for every month..

here is my content,

exec dbms_stats.gather_table_stats('TEST', 'EMPLOYEETABLE', GRANULARITY => 'PARTITION',PARTNAME => 'YR14_P12');

i want to dynamically assign the partname value to something like "YR15_P1","YR15_P2","YR15_P3" and so on.. need some advice on how to accomplish this?

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