RE: Change tablespace of partitioned table

[Khedr, Waleed]

Title: Change tablespace of partitioned table

alter table <table name> modify default attributes tablespace <tablespace_name>

Regards,

 

Waleed

 -----Original Message-----
From: Seefelt, Beth [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L
Subject: Change tablespace of partitioned table

Hi all,

I moved a partitioned table to a new tablespace by using
        alter table ... move partition ...

Moving it was no problem, but when I now try to split or merge partitions, Oracle wants to put the new partitions in the old tablespace.  I think because that is the tablespace that's set at the table level.

Can I change the tablespace that the table is associated with?  I tried

        alter table... move tablespace

but you can't do that on a partitioned table.

thanks,

Beth