Home » SQL & PL/SQL » SQL & PL/SQL » Exchange Partition (Oracle 11g)
Exchange Partition [message #661108] Wed, 08 March 2017 00:33 Go to next message
saipradyumn
Messages: 361
Registered: October 2011
Location: Hyderabad
Senior Member
[code]
Hi All,

I have one Range partitioned table on date column and another non partitioned tables. I want to exchange the data between these two tables .

I am using the exchange partition table concept with the following command :
alter table tc_partitioned  exchange partition C_12FEB2016 with table non_partitioned ;

Error report -

SQL Error: ORA-14099: all rows in table do not qualify for specified partition
14099. 00000 -  "all rows in table do not qualify for specified partition"
*Cause:    There is at least one row in the non partitioned table which
           does not qualify for the partition specified in the ALTER TABLE
           EXCHANGE PARTITION
*Action:   Ensure that all the rows in the segment qualify for the partition.
           Perform the alter table operation with the NO CHECKING option.
           Run ANALYZE table VALIDATE on that partition to find out the
           invalid rows and delete them.
 

Please help me to resolve the issue
Re: Exchange Partition [message #661109 is a reply to message #661108] Wed, 08 March 2017 00:57 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What about what the "Action" tells?
You cannot exchange a table with a partition if ALL the rows in the table does not match the partition value for this partition.
What do you expect from us?

Re: Exchange Partition [message #661110 is a reply to message #661109] Wed, 08 March 2017 01:43 Go to previous message
saipradyumn
Messages: 361
Registered: October 2011
Location: Hyderabad
Senior Member
Thanks Michel .

Your information itself resolved the issue
Previous Topic: Enable novalidate constraint
Next Topic: which is best to locate row in oracle table
Goto Forum:
  


Current Time: Fri Oct 19 07:59:24 CDT 2018