synonyms for database tables

Hi. I have a problem with two instances of database each on a different machine. All that in Instance 1 should be synonyms pointing to Instance 2 which has the actual tables. All processes (4ge) are carried out on Instance 1. One of the processes is to modify a row in table A and move the original data into the audit table A'. During this update of data, a new serial number should go into table A to indicate the version of the data. Somehow there was a mistake in which table A was put into Instance 1 and the result was when updating the data the new data went into the audit table. However the new serial number still went into emr_dl_cons_hist. So, new data with old serial number into audit table and old data with new serial number in table A. After table A has been moved to Instance 2 and synonyms restored, the problem went away. Any idea what is happening? Regards. Sent via Deja.com http://www.deja.com/ Before you buy.