Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query the remote DB date over a db link

553520Sep 28 2007 — edited Sep 28 2007

Hi,
I am trying to query the current date (sysdate) of a remote DB while connected to local DB. But when i execute the query sysdate@dblink it returns me the local database time and date.

I want to finally do this in OWB repository. I have two modules source and target. I need to query the source system date and time. I cannot create any views or functions on the source. I have read only privilege on the source DB.

Any help on this would be great.

Thanks,
Ankit

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 26 2007

Added on Sep 28 2007

#data-warehousing, #warehouse-builder

4 comments

1,003 views