Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exchange Partition

jjkApr 14 2010 — edited Apr 15 2010
Hello everyone,
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

I've two tables PART_TEMP1 (day wise PARTITIONED BY RANGE ON COL2) & NOPART_TEMP2 (NON-PARTITIONED)

TABLE STRUCTURE IS SAME FOR BOTH
Name Null? Type
----------------------- -------- --------------------------
COL1 VARCHAR2(10)
COL2 DATE

When I exchanged partitions with below statement it was successful.
ALTER TABLE PART_TEMP1 EXCHANGE PARTITION APR14 WITH NONPART_TEMP2;

But now I want to exchange (from part_temp1 to nonpart_temp2 table) APR15 partition
ALTER TABLE PART_TEMP1 EXCHANGE PARTITION APR15 WITH NONPART_TEMP2;
Then I get below error
ORA-14099: all rows in table do not qualify for specified partition

All I want to do is move data from PART_TEMP1 TO NONPART_TEMP2. But second time, it seems that it's doing vice-versa

I want to know where I'm going wrong.

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2010
Added on Apr 14 2010
6 comments
1,399 views