Re: Migration/Refresh tool
From: Magnus Andersen <mag.andersen_at_gmail.com>
Date: 9 Jan 2006 13:01:33 -0800
Message-ID: <1136838596.254148.44540_at_g14g2000cwa.googlegroups.com>
Date: 9 Jan 2006 13:01:33 -0800
Message-ID: <1136838596.254148.44540_at_g14g2000cwa.googlegroups.com>
[Quoted] I guess I still don't understand how this would work. I apologize for my ignorance. Here is my scenario...
Schemas
sysadm_a
sysadm_b
Tables
sysadm_a.ps_cm_prodcost
sysadm_b.ps_cm_prodcost
Synonyms
create synonym ps_cm_prodcost for sysadm_a.ps_cm_prodcost
create synonym ps_cm_prodcost for sysadm_b.ps_cm_prodcost
When I log into the database as magnus and query ps_cm_prodcost, what table will I query and why?
Again, I'm sorry for my ignorance, but I don't understand.
Thanks,
Magnus
Received on Mon Jan 09 2006 - 22:01:33 CET