Oracle connector Usage

vskr72 · Post by **vskr72** » Thu Jan 12, 2012 9:26 pm

We have certain jobs that use Oracle connector. I just want to understand if the it can handle the following:
- Table being loaded ran out of extents or the tablespace ran out of room?
- Network disconnect, database outage, or other issue that prevents data from being loaded?

The question is whether these kinds of events can be captured in the Oracle Connector reject link.

chulett · Post by **chulett** » Thu Jan 12, 2012 9:30 pm

That's not what a 'reject' link is for. The events you mention will cause the job to abort, not records to be rejected.

qt_ky · Post by **qt_ky** » Thu Jan 12, 2012 10:05 pm

All those examples require someone, like a DBA or network person, to take action. In cases like those, you can set your sequence job to detect the abort job status from the job with the Oracle Connector stage. You can have the sequence job email to one or more people, to a help desk, or to a mail group, etc. to alert them.