DBLink to Oracle

When a project encounters a problem with Oracle and SQL Server sharing data with each other, Oracle builds DBLink to SQL Server to write data that doesn't seem to work (Oracle says), and then uses SQL Server to build DBLink to write data to Oracle.

--([] all in uppercase)--Access Oracle data TablesSelect *  from [Linked server name]..[User name].[Table name]Select *  from OPENQUERY([Linked server name],'SELECT * from Test1')  --inserting Oracle data tablesInsert  into [Linked server name]..[User name].[Table name]    Select *  from [Local table name]

The linked server name is Dblink's name.

DBLink to Oracle