Re: How to change the tablespace of a subpartitioned partition
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 13 Nov 2008 18:05:05 -0800
Message-ID: <1226628290.83895@bubbleator.drizzle.com>
>
> Found it! Thanks Daniel. Calling it "modify *table* default attrs"
> threw me of the track.
>
> Regards,
> Jaap.
Date: Thu, 13 Nov 2008 18:05:05 -0800
Message-ID: <1226628290.83895@bubbleator.drizzle.com>
Jaap W. van Dijk wrote:
> 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.
I'll clarify that with the next upload.
-- 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.orgReceived on Thu Nov 13 2008 - 20:05:05 CST