Home » SQL & PL/SQL » SQL & PL/SQL » partition exchange
partition exchange [message #250678] Tue, 10 July 2007 16:25 Go to next message
arik_x
Messages: 6
Registered: July 2007
Junior Member
Can composite potitioned table exchange partition ?

I used this syntax:

ALTER TABLE table_a EXCHANGE PARTITION partition_x WITH TABLE
table_b INCLUDING INDEXES WITHOUT VALIDATION UPDATE GLOBAL INDEXES

and I've got an error:


ORA-14292: Partitioning type of table must match subpartitioning type of composite partition

both tables have the same paritions/subparitions/columns etc...

thanks

Re: partition exchange [message #250680 is a reply to message #250678] Tue, 10 July 2007 16:48 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
How is this post different from
http://www.orafaq.com/forum/m/250395/74940/#msg_250395
Re: partition exchange [message #250682 is a reply to message #250678] Tue, 10 July 2007 17:05 Go to previous messageGo to next message
arik_x
Messages: 6
Registered: July 2007
Junior Member
the problem is that I need to exchange partiton between two composite tables

The first table is
'PARTITION BY RANGE (column a, column b)
SUBPARTITION BY HASH (column c)'

and the second table is
'PARTITION BY RANGE (column a, column b)
SUBPARTITION BY HASH (column c)'
Re: partition exchange [message #250692 is a reply to message #250682] Tue, 10 July 2007 21:36 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You have to do it in two steps.
1. Exchange a single range-partition with a hash-partitioned (non-sub-partitioned) table
2. Exchange the hash-partitioned table with the range partition of the target table.

Ross Leishman
Previous Topic: update changes all records!
Next Topic: QUERY PROBLEMS: PLEASE HELP
Goto Forum:
  


Current Time: Fri Dec 09 13:28:42 CST 2016

Total time taken to generate the page: 0.10990 seconds