Re: How to change the tablespace of a subpartitioned partition

From: Jaap W. van Dijk <>
Date: Thu, 13 Nov 2008 17:19:09 GMT
Message-ID: <>

On Wed, 12 Nov 2008 09:22:57 -0800, DA Morgan <> wrote:

>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

Found it! Thanks Daniel. Calling it "modify *table* default attrs" threw me of the track.

Jaap. Received on Thu Nov 13 2008 - 11:19:09 CST

Original text of this message