Convert a nonpartitioned table into a partitioned table
I have a big nonpartitioned table and want to convert it into a partitioned table.
I've read about "exchange partition" method but I would like to know if someone has any experience on this that can share advantage and disadvantages of this. The article just shows a simple scenario and I would like to cover errors or troubleshouting.
What I am trying to check is if this process will need extra disk space or if it will take to much as I don't have enough for now.
Is this a process that can affect database performance?
Is there any other method I can use instead of exchanging partition? If there is one, what are the advantages and disadvantages.