Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to move a partitioned table from one tablespace to another ?

Re: How to move a partitioned table from one tablespace to another ?

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Thu, 24 Jun 2004 22:59:10 +1000
Message-ID: <40dad018$0$18195$afc38c87@news.optusnet.com.au>


André Hartmann apparently said,on my timestamp of 24/06/2004 10:17 PM:

>
> How can I move a partitioned table ? The "partition bla_part" clause that
> works in a SELECT or DML statement wont work here :(
>

Go here:
http://tinyurl.com/32rov
and follow the links to "alter table partitioning". The bit you want is the one under "move table partition".

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
Received on Thu Jun 24 2004 - 07:59:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US