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