Hi Ray,
Yes, the tables are good in Oracle, and I can acess them by using "Aqua Data Studio", "PL/SQL Developer" and "SQL Plus". I imagine the problem is related to oracle, but might it is not only with Oracle but some configuration between datastage and oracle which is not well done.
The problem is difficult because the environment in France is the same and the problems do not happens there. I have two dbas working on it and they found no problems in the environment.
Also, the most common error is this one, which brings no database related message, but it only happens in jobs which have oracle tables being readen or written. The oracle logs do not bring any error for this one!
Err1
===================================
Internal Error: (blockSizeActual >= v4BlockHeader::size ()): datamgr/partition.C: 410
Traceback: [6] APT_FatalPath::pureAssertion(0xfed91f06, 0xfed91f30, 0x19a, 0x7400, 0xcc1a0, 0x0), at 0xff0d939c
[7] APT_DMBlockedPartition::reset(0x40eb80, 0x0, 0xfdba8010, 0x0, 0x5, 0xfed91f30), at 0xfe838f58
[8] APT_DMBlockedPartition::readBlock(0xffbfc7c0, 0x40eb80, 0x0, 0x0, 0xffbfc6ec, 0x100000), at 0xfe8398e0
[9] APT_DMProcessPartition::readFinishStatus(0x40eb80, 0xfc00, 0x53ee30, 0xa, 0xa, 0x0), at 0xfe840a08
[10] APT_DMInputCursor::closeSegmentPartitions(0x53ed08, 0x1, 0xfee567c8, 0xfe807b38, 0xfee18f60, 0xffbfc85c), at 0xfe807c10
(...)
===================================
Anyway, I think I will ask the dba to involve oracle too.
Thanks for your answer and if you have other ideas please tell me.
ray.wurlod wrote:These problems do seem to be coming out of Oracle. Can you successfully access the same tables through other clients, like sqlplus or TOAD ?
You may need to get Oracle support or your DBA involved ...