Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database link not working properly from 10g to 9i database

731777Dec 31 2009 — edited Jun 10 2010
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2010
Added on Dec 31 2009
#database, #dba, #general-database-discussions, #oracle, #sql
9 comments
3,924 views