err:Hostdef not found [message #2438] |
Tue, 16 July 2002 09:40 |
Abu 'Ubaidah
Messages: 6 Registered: June 2002
|
Junior Member |
|
|
Running the query below on oracle(2)8i: throws an error
ora 01041 (internal error) 'hostdef not found'.
(cube80 is a database link)
select
a.cif_id,
a.cust_name,
'' "Branch",
'Contingent' "Type of Facility",
max(a.expiry_date) "Expiry Date",
null "Principal Bal.",
null "Int & Other Suspense Charges",
nvl(get_contigent_bal@cube80(a.cif_id),0) "Contingent Liability",
0 "Undrawn Facility",
c.cod_mis_cust_code_2 "Sector",
0 "Value of Security",
'' "Type of Security",
'' "Classification",
null "Provision Made"
from lctbs_contract_master @cube80 a,
lctb_availments @cube80 b,
ci_custmast c
where a.contract_ref_no = b.contract_ref_no
and c.cod_cust_id = a.cif_id --cross link comparison
and b.os_liability > 0
and ( b.contract_ref_no, b.event_seq_no) IN ( select contract_ref_no, max(event_seq_no)
from lctb_availments @cube80 group by contract_ref_no)
group by a.cif_id,a.cust_name,c.cod_mis_cust_code_2
/
Please help to fix.
|
|
|
Re: err:Hostdef not found [message #2442 is a reply to message #2438] |
Tue, 16 July 2002 12:51 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
This error occurs usually when the connection to the database on the remote server is lost or a Server process is killed .If the database is shut down and you try to connect to it from the client machine you will get the above error. You need to look into trace/logs for more diagnosis and origin of the error.
|
|
|