caramelkaps (4/10/2012)

---

Hi,

We have a very time sensitive pressing requirements to be addressed immediately.

We need to read the date time column from sql server into oracle 10g.

We have a dblink established between the two servers and have tried to use sql server and sql native client 10 driver to read the dates from sql into oracle.This we are able to do very successfully.

The issue is in reading microseconds stored in sql server.The microsecond part comes in as 00000 from sqlserver to oracle.These microseconds are needed to identlfy the unique records.

For instance

SQL SERVER Oracle

source_id source id

01/01/2012 6:30:35:456 01/01/2012 6:30:35:000000.

Any insight or help will be much appreciated.

We have no control over sql server Db as this is remote third party DB.We just have select access to their tables to bring into our own oracle DB.