ALTER TABLE EXCHANGE

[badrinathn]

Hi,

With the suggession about loading the data from the existing table into the partitioned table, I tried and was successful.

However, I have a problem. In my partitioned table I have 2 partitions ,(one for company type H, and other for company type E). The existing table had both type of companies.

Partition PART01 IS FOR COMPANY TYPE 'E'
Partition PART01 IS FOR COMPANY TYPE 'H'


When I use
ALTER TABLE REI_ACCOUNT_PART
EXCHANGE PARTITION PART01 WITH TABLE REI_ACCOUNT WITH VALIDATION

I GET
ERROR at line 2:
ORA-14099: all rows in table do not qualify for specified partition

IS there any way that, I load the data from main table (REI_ACCOUNT) into rei_acount_part, when it loads respective records into respective partitions.

Hope my ques is clear, else I will explain my ques again.


Please suggest me
Badrinath

[sln81]

Whenever you exchange partition with a table, it is a two-way exchange. Your table might have got data which might have to go into both the partitions. But, whenever ypu exchange data, it will be only with one partition. That is where you are encountering the error.
Use simple insert command with a subquery to insert rows into the partitioned table