Small problem in table move
460177Mar 15 2006 — edited Mar 16 2006The base table was created in a DMT and all the partitions were created in LMT.
Now i want the table also to be in LMT.
When attempted a move with alter table tablename move tablespace it's giving an error.
SQL> ALTER TABLE HOLDINGDBO.POSITION_STAGE MOVE TABLESPACE HOLDING_GEN;
ALTER TABLE HOLDINGDBO.POSITION_STAGE MOVE TABLESPACE HOLDING_GEN
*
ERROR at line 1:
ORA-14511: cannot perform operation on a partitioned object.