Re: How to change the tablespace of a subpartitioned partition
Date: Thu, 13 Nov 2008 17:19:09 GMT
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 18.104.22.168.
>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
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