Hi Experts,
We have an existing table with about 3 billion records without partition. The plan is to create a new table to insert last 2 years of data with monthly wise partitioned. so our reporting will be extracted much faster.
The structure of the table1 and table2 to be same and table2 is inserted from table1 records on daily basics through job. In table 2 the partition to be dropped suppose it exceeds 2 years. Please guid me how to achive this . how to create the table 2 with 2 years data? and how to auto partion name?