Database link not working properly from 10g to 9i database
731777Dec 31 2009 — edited Jun 10 2010I am having two seprate databases/servers.Out of which one is oracle 9i other is 10g.
My requirement is to connect 10g to 9i to extract the data and create the same table in 10g database through the database link which i have created.I am getting the following errors.
Please help me out to get this issue resolved.
select * from table_name@db_link_name
ORA-02051: another session in same transaction failed
ORA-02063: preceding line from MUM2MIS
sometimes this error also i am getting
ORA-02068: following severe error from MUM2MIS
ORA-03135: connection lost contact
select * from dual@db_link_name is working fine.
select * from table_name@db_link_name where condititon selecting less number of rows is also working fine.
Regards,
Vairamuthu M