Rename Partioned Table
262173Dec 27 2002 — edited Dec 30 2002I have several tables that contain >85mill rows. I plan to create a shadow table and create 36 partitions (by month) and insert the records from the old table into the new table.
The next step is to drop the old table and rename the new table to the old table name. I hope this will not cause any problems with the application above the database (which is SAP BW).
Any advice if this method will cause problems.
Thanks in advance.