Partition Exchange Loading (PEL) error
593332Jan 19 2009 — edited Apr 13 2009This is what I did so far (direct PEL):
1. create partition on the target table.
2. create local index and PK on target, and check 'using index' for the PK constraint in the table property.
3. create staging table with the same structure as target (but global index this time), and also check the 'using index' option.
4. check 'using PEL' for target table.
My table is partitioned by year. It runs fine when I run the first time, lets say data from 2008 and 2009. But when I run the 2008 data for the second time, it truncate the whole table (both 2008 and 2009) and load the 2008 data. I mean looks to me it is doing the normal loading, not PEL. What am I missing here?
Thanks so much.