How to change the tablespace of a subpartitioned partition

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Tue, 11 Nov 2008 22:49:39 -0800 (PST)
Message-ID: <b90c7704-fa37-4945-aa43-3ffdc0dc8aa3@f40g2000pri.googlegroups.com>

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. Received on Wed Nov 12 2008 - 00:49:39 CST

This message: [ Message body ]
Next message: Laurenz Albe: "Re: Why Oracle does not allow rollback of DDL statements?"
Previous message: sybrandb_at_hccnet.nl: "Re: Why Oracle does not allow rollback of DDL statements?"
Next in thread: DA Morgan: "Re: How to change the tablespace of a subpartitioned partition"
Reply: DA Morgan: "Re: How to change the tablespace of a subpartitioned partition"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message