Re: How to change the tablespace of a subpartitioned partition

From: DA Morgan <>
Date: Wed, 12 Nov 2008 09:22:57 -0800
Message-ID: <>

Jaap W. van Dijk wrote:
> I have a subpartitioned table with an undesired value for the
> tablespace of the partitions. How do I change those?
> I tried to MOVE them, but that is not allowed (ora-14257), because the
> table is subpartitioned.
> I tried to MODIFY then, but that is not a valid syntax.
> My version is
> Regards,
> Jaap.

The correct syntax is in Morgan's Library at under Partitioned Tables.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Nov 12 2008 - 11:22:57 CST

Original text of this message