Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DB Links
On Feb 9, 6:55 am, rumkibhad..._at_gmail.com wrote:
> Can DB Links be used to connect to different oracle and non oracle
> databases at the same time? For example, Oracle 8.1.2, Sybase 11, SQL
> Server 2000, SQL Server 6.5 ?
>
> Regards,
> Rumki
You would need to configure Heterogeneous Services for that. The foreign database will get a properly configured entry in tnsnames.ora, this can be used in the database link definition
-- Sybrand Bakker Senior Oracle DBAReceived on Fri Feb 09 2007 - 03:21:54 CST