Set up a trigger on insert to check for the existence of the partition table, then it could do the insert there or create the table if needed and insert. Look online. I know I’ve seen examples of this.
—
Jay
Sent from my iPad
> On Nov 9, 2017, at 6:28 PM, rammohan ganapavarapu <rammohanganap(at)gmail(dot)com> wrote:
>
> Hi,
>
> I have a requirement to create monthly partitions in my db, i am trying to understand what is the best way to do it, i know i can run a cron job to check if partition exist and create if not at the starting of month. Any suggestions?
>
> Thanks,
> Ram