Hi Ann,
Are the two databases in 8.1.6?
By the way be care with inserting through database link in 8.1.6 because there is a bug:
1. Select count(*) from table_name@db_link;
X rows
2. Insert into table_name
select count(*) from table_name@db_link;
Different number of rows that the first query
Regards
Angel




Reply With Quote