Hi all,
I moved a partitioned table to a new tablespace by using
alter table ... move partition ...
Moving it was no problem, but when I now try to split or merge partitions, Oracle wants to put the new partitions in the old tablespace. I think because that is the tablespace that's set at the table level.
Can I change the tablespace that the table is associated with? I tried
alter table... move tablespace
but you can't do that on a partitioned table.
thanks,
Beth