Re: How to change the tablespace of a subpartitioned partition

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 9.2.0.5.
>
> Regards,
> Jaap.

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

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org