Home > IT Answers > Oracle > data from oracle 10g to oracle 8i
Skarthik3
5 pts.
 data from oracle 10g to oracle 8i
Oracle 10g, Oracle 8i, Oracle error messages
Im using oracle 10g and thru trigger i want to move data to oracle 8i for one particular table. when i try the trigger between two oracle 10g using database link its working fine. but from 10g to 8i giving error like ORA-04052: error occurred when looking up remote object

Software/Hardware used:
ASKED: June 8, 2008  11:26 AM
UPDATED: June 10, 2008  8:10 AM
RELATED QUESTIONS
Answer Wiki:
Hi, does the link work fine outside the trigger? What happens if you simply test it, using for example: SQL> desc username.tablename@dblinkname M.
Last Wiki Answer Submitted:  June 10, 2008  8:10 am  by  FreCho   80 pts.
All Answer Wiki Contributors:  FreCho   80 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _