mruff
asked on
Oracle export for DB2 import
Dear experts
We are looking for a mechanism to export table content from oracle and import in db2 on a mainframe.
We would prefer to produce fixed record dumps from oracle which can be imported by the mainframe db2 loader utility.
The preferred solution would be to use: expdp, it would be great to get a sample config file to achieve fixed record length export which is importable for db2
as plan B we would have to fall back to write a small java pgm, but I'd prefer option A
Many thanks for your support
We are looking for a mechanism to export table content from oracle and import in db2 on a mainframe.
We would prefer to produce fixed record dumps from oracle which can be imported by the mainframe db2 loader utility.
The preferred solution would be to use: expdp, it would be great to get a sample config file to achieve fixed record length export which is importable for db2
as plan B we would have to fall back to write a small java pgm, but I'd prefer option A
Many thanks for your support
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.