Sybase to Oracle

xch2005 · Post by **xch2005** » Thu Jun 02, 2011 2:08 pm

Hi,

I am trying to load 16 Oracle tables from Sybase in parallel. Randomly some table or other fails in the process due to connectivity issue.

We my sequence job starts all the jobs run in parallel, is this correct way of performing the data load. We are having in this way to have better completion time.

It is basically a direct load and no calculations are done.

Is there any other alternate way to acheive this?

Thanks

chulett · Post by **chulett** » Thu Jun 02, 2011 2:09 pm

Define "connectivity issue".

ray.wurlod · Post by **ray.wurlod** » Thu Jun 02, 2011 4:53 pm

Make sure your Oracle DBA has configured a sufficient number of listeners.

chulett · Post by **chulett** » Thu Jun 02, 2011 7:53 pm

There's typically just one but the limit on the max number of and/or rate of connections could be too low. Depends on how this "connectivity issue" manifests itself.

synsog · Post by **synsog** » Fri Jun 03, 2011 10:59 am

The error message which I got was,
Fatal: ct_fetch failed or canceled during fetch to Sybase table which is the source stage

ray.wurlod · Post by **ray.wurlod** » Fri Jun 03, 2011 4:00 pm

And this is related to the problem reported by xch2005 how?

xch2005 · Post by **xch2005** » Tue Jun 07, 2011 10:14 am

Now split up the jobs into batches and executing them from sequence