var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ORA-14099: all rows in table do not qualify for specified partition
I'm trying to use exchange partition on a table.
Tab1 is partitioned on period (yyyymm) and has data for 201102
Tab2 is not partitioned and has NO data for 201102.
Both tables have the same number of columns.But when I give the following to do an exchange partition, I get the below error.
Since tab2 doesnt have data for 201102 causing this problem? Any inputs is appreciated.
Alter table tab1 exchange partition tab1_201102 with table tab2;
ERROR at line 1:
ORA-14099: all rows in table do not qualify for specified partition
o yes, that is the problem. The table I'm trying to exchange partition with has no data for that period.