need help on shell scripting
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!