Re: SYNONYMs revisited

On Wednesday 04 March 2009 16:34:54 Joshua Tolley wrote:
> Way back in this thread[1] one of the arguments against allowing
> some version of CREATE SYNONYM was that we couldn't create a synonym for
> an object in a remote database. Will the SQL/MED work make this sort of
> thing a possibility?

The idea is that SQL/MED will create objects known as foreign tables that 
represent remote resources but work locally like a normal table.  So in some 
sense, SQL/MED already creates a local synonym-type thing for remote 
resources anyway, so there is no need to create a separate synonym in the 
Oracle sense on top of that.