Home » RDBMS Server » Server Administration » dblink error
dblink error [message #217616] Sat, 03 February 2007 03:33 Go to next message
airother
Messages: 27
Registered: February 2006
Junior Member
Hi all,


on 9i server we have one user which uses some tables from other server's user tables(there 10g is install) through DBlink.

now we upgrade 9i server to 10g,but we can't able to fetch the function based data from dblink.
when we fire any query with functions like to_char,to_date in WHERE clause our session automatically disconnect.

This problem comes after upgradation

so tell me solutions!!!!!!!!


thanks and regards

Ajit

Report message to a moderator

Re: dblink error [message #217633 is a reply to message #217616] Sat, 03 February 2007 09:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Do you see any errors in the alert log? Are any trace files being generated?

Report message to a moderator

Re: dblink error [message #217763 is a reply to message #217633] Mon, 05 February 2007 06:03 Go to previous messageGo to next message
airother
Messages: 27
Registered: February 2006
Junior Member
hi,
trace file genrated but i can't able to trace out the problem
through that file.

Report message to a moderator

Re: dblink error [message #218818 is a reply to message #217763] Sat, 10 February 2007 14:21 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
airother wrote on Mon, 05 February 2007 07:03
hi,
trace file genrated but i can't able to trace out the problem
through that file.

Well neither can we without seeing the contents of the file.

Report message to a moderator

Previous Topic: Create B*Tree cluster for existing tables
Next Topic: Query Performance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 15:47:48 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.