ORA-32690: Hash Table Infrastructure ran out of memory.
Is there any workaround for this, other than upgrading?
Search found 3 matches
- Sat Feb 19, 2011 6:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-32690: Hash Table Infrastructure ran out of memory
- Replies: 2
- Views: 4499
- Sat Feb 19, 2011 5:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: direct parallel loading unless an index option is included.
- Replies: 3
- Views: 3667
Re: direct parallel loading unless an index option is includ
Thankyou very much both of you!!!! It solved the issues, actually there was no unique constrain so I tried with the first option, and it is good to go.. 1) Select an index option in the database stage you are writing with. Typically you may elect to rebuild the index, but other options may be present
- Fri Feb 18, 2011 1:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: direct parallel loading unless an index option is included.
- Replies: 3
- Views: 3667
direct parallel loading unless an index option is included.
The ETL interface Job got aborted today due to be below error message.Looks like this is error ralated to Database(PMMPROD). Error msg: Indexes on table 'MWW_19C_EXT' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step. Kindly sugge...