Quote Originally Posted by kholger
2. exchange table target_table with new_table
What do you mean with exchange? Does this also adapt the foreign keys on the target_table to new_table?
http://download-west.oracle.com/docs...titi.htm#11985

and I forgot:
5. split your one partition table to the partitions you really want.