Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Posts
    276

    Unanswered: ORA-14099: all rows in table do not qualify for specified partition

    Hi all,
    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.

    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
    Since tab2 doesnt have data for 201102 causing this problem? Any inputs is appreciated.

    Thanks!

  2. #2
    Join Date
    Jul 2005
    Posts
    276
    o yes, that is the problem. The table I'm trying to exchange partition with has no data for that period.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •