effects of renaming partitioned Table
We have a partitioned table CALL and this is partitioned according to the months.One of it's partitions has grown to around 56 GB and is still growing as data for forthcoming months is also going into this partition.
This CALL table has several procedures as well as packages associated with it. Now we have decided to rename this table and then re-create a new partitioned table month wise and then copy the data back into this new table. But the problem is that when i rename the table all my procedures and packages will get invalid ,
My Questtion is that when i create a new partitioned table CALL then will all my procedures and packages get validated and also my application will get back to normal.
Thanks and Regards