I am facing a query and need help to solve that which is regarding to table partitions.
WE have table(Non - Partitions) with 7 cores of record. Now we want to partition that table so what is the easiest way to do it?
We are trying to create a temp table with partitions, and insert(using parallel of 8 and nologging) total data into that. And then rename temp table as original.
But it is taking a long time to insert that much amount of records.
Please suggest me if there is any better way to handle this.
Thanks in Advance.