Partitioned to Non Partitoned Table

[lesstjm]

I want to move a partitioned table to a non partitioned table. I see that there is a exchange partition command but there are some things I do not understand about it. The first thing is do I have to create a table that matches the structure of the partitioned table first and then use the exchange command or does the exchange command create the table for me? Also, once I move the data to this new table I know I can rename the table back to the original table's name once I drop the partitioned table but then I lose all of the privileges and grants on that original table. Is there a way to preserve those?

[Axr2]

1. You need to create the table with matching structure.

2. Renaming a table transfers grants associated with the old table to the new table. So make sure that your new table from step1 has identical grants as partitioned table.