Message-Id: <10521.108165@fatcity.com> From: "Stephen J Palmer" Date: Wed, 07 Jun 2000 22:20:56 -0400 Subject: dblin help needed This is the first time I've had a problem with database links. Any idea what is going on here? I have dropped and recreated the link several times, and bounced the database instance. The LGWR proccess IS running and I can connect to the instance. 21:28:32 SQL> create public database link BRKTEST connect to mtuser identified by password using 'brktest'; Database link created. 21:32:46 SQL> @links.rep Wed Jun 7 page 1 DATABASE LINK REPORT Owner Name Username Host Created --------------- ----------------- -------------- --------- --------------- PUBLIC BRKMT MTUSER brktest 10-MAY-00 PUBLIC BRKTEST MTUSER brktest 07-JUN-00 21:29:06 SQL> select sysdate from dual@brktest; select sysdate from dual@brktest * ERROR at line 1: ORA-00470: LGWR process terminated with error ORA-02063: preceding line from BRKTEST Any thoughts would be appreciated. Thanks in advance.