Re: Problems when using distributed SQL??

> I create table1 on machine1 and table2 on machine2. I connected
> locally on machine1 and created a "PUBLIC DATABASE LINK
> machine2.domain.org CONNECT TO user IDENTIFIED BY password USING
> 't:machine2.domain.org'"

This is a SQL*Net version 1 connect string. Perhaps you are using SQL*Net version 2, in which case you would want:

CREATE PUBLIC DATABASE LINK machine2.domain.org CONNECT TO user

	IDENTIFIED BY password 
	USING 'machine2.domain.org';