Re: How to change the tablespace of a subpartitioned partition

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Thu, 13 Nov 2008 17:19:09 GMT
Message-ID: <491c60b0.1738296@news.hetnet.nl>


On Wed, 12 Nov 2008 09:22:57 -0800, DA Morgan <damorgan_at_psoug.org> 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 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

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

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

Original text of this message