Support for Oracle Partitioning

seanc217 · Post by **seanc217** » Fri Apr 21, 2006 12:59 pm

I have a simple job sequential file -> transformer -> Oracle enterprise
The table I am loading into is partitioned by a date field. I have specified in my job that Oracle should disable the constraint (which is a local index).

So when the job starts DataStage drops the index and disables the constraint. When the job finishes it re-creates the index.

When DataStage re-creates the index, it creates it as a normal index not local which is not good when utilizing partitioning.

Any ideas?

Thanks

ray.wurlod · Post by **ray.wurlod** » Fri Apr 21, 2006 3:13 pm

Adjust the CREATE INDEX command?

seanc217 · Post by **seanc217** » Thu Apr 27, 2006 2:16 pm

fyi on this issue:

I just talked to IBM support.
This is going in as a enhancement request.

Until then, I have scripted a work around.

The workaround will load the table into a temporary normal table with a primary key. I then use the alter table exhchange partition...including indexes to move the data over to the partitioned table. It works quite well and my load times are more consistant.

Thanks