Search found 3 matches
- Wed Oct 31, 2007 9:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading Oracle table that has indexes and partitions
- Replies: 3
- Views: 1595
Sorry for not giving more specifics, I should have done that initially. Options for Load in DataStage are: - Disable Constraints = True - Index Mode = Maintenance - others are not pertinent to this discussion Here is selected info from the SQL Loader LOG file: Table PRICE_HIST, partition PH_T_PART00...
- Wed Oct 31, 2007 8:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading Oracle table that has indexes and partitions
- Replies: 3
- Views: 1595
- Tue Oct 30, 2007 4:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading Oracle table that has indexes and partitions
- Replies: 3
- Views: 1595
loading Oracle table that has indexes and partitions
I am not very knowledgeable about DataStage, yet I have been put on a project where we will be using it. I am having some issues with loading to an Oracle table that has 78 partitions and 4 indexes. When I set the stage to use the "Load" option, it seems to have problems properly dropping and recrea...