How to move a partitioned table from one tablespace to another ?

From: André Hartmann <andrehartmann_at_hotmail.com>
Date: Thu, 24 Jun 2004 14:17:49 +0200
Message-ID: <40dac670@olaf.komtel.net>

Hi there,

I want to move the data of a whole schema from one tablespace to another and I have no problem with unpartitioned tables and indexes:

ALTER TABLE bla_tbl MOVE TABLESPACE bla_tblspc; ALTER INDEX bla_idx REBUILD TABLESPACE bla_tblspc2;

However partitioned tables wont work this way:

ALTER TABLE bla_tbl_partitioned MOVE TABLESPACE bla_tblspc;

ERROR in line 1:

ORA-14511: cannot perform operation on a partitioned object

How can I move a partitioned table ? The "partition bla_part" clause that works in a SELECT or DML statement wont work here :(

André

:) Received on Thu Jun 24 2004 - 07:17:49 CDT