We have a 8i database named 'alphaDB' on a win2k machine named
'Alpha', another 9i database named 'betaDB' on another win2k machine
named 'Beta', an 8i client on a win98 machine named 'Gamma'.
I was working on a stored procedure that would parse and then transfer
data from a a couple of tables from alphaDB to betaDB. This stored
procedure is to be executed from 'Beta', i.e. from the 9i database.
Tables on 'Alpha' are accessed via database link.
Earlier everything was working fine, but now whenever I try to access
a particular table named emp_inf, I get following error:
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Interesting thing is that I can access other tables without any
problem, I can even access the very same table through sqlplus, but
this problem occurs only when I try to access that particular table.
I guess that possibly there is certain problem with the server, but
which server I should be concentrating on? The one where script is
being executed or the one where the table is existing?
Any suggestions....
With Regards,