Hi
I don't think you can move a table into a partition. The move clause of the alter table statement allows you to move to a table to a new tablespace or change the storage parameters for existing data.
Does anyone else have any thoughts on the best way to partition an already populated table?
Cheers
Moff.




Reply With Quote