First time here? Check out the FAQ!
x

Can Oracle IBM DB2 connect to IBM DB2 on mainframe to allow data importing from DB2 to Oracle?

0 votes
asked by
edited by

I need to connect to a DB2 on a mainframe in order to import data to Oracle. However, after connecting to both DB2 and Oracle, the application gives an error "Object or provider is not capable of performing requested operation. Run-time error '3251' "

1 Answer

0 votes
answered by (100k points)

You will need to check the path where the databases are stored. If the path exceeds 128 characters then you will encounter an error when you are trying to import or migrate the databases. Relocate the files to a path with under 128 characters and you should be good to go.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...