Hi Team,
I need to develop a parallel job to migrate tables from sybase to oracle server.
I'm using sybase connector and oracle connector with create target table YES and RCP enabled in job properties.
but getting below error in the oracle stage,though enabled RCP
The connector could not validate the input schema,specify atleast one column in the input schema.
Please help.
Generic job to migrate tables from sybase to oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Wed May 15, 2013 1:22 am
- Location: Bangalore
Generic job to migrate tables from sybase to oracle
Cheers,
Schindler
Schindler
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Last time I did one of these (different souce and target from yours) I used a sequence to run a server job that created the SELECT statement by reading the system tables, and passed the SELECT statement to the main job as a job parameter. Worked beautifully.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.