Current Timestamp over DB Link
- From: Maris Elsins <elmaris@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 18 Jun 2014 15:02:02 +0300
HI All,
I'm trying to compare the local and remote timestamps to assess the time
offset between 2 DBs, but this query gives the local timestamp only:
SQL> select systimestamp local_time, (select systimestamp from
dual@REMOTE_DB) remote_time from dual;
LOCAL_TIME
---------------------------------------------------------------------------
REMOTE_TIME
---------------------------------------------------------------------------
18-JUN-14 07.00.06.611471 AM -05:00
18-JUN-14 07.00.06.611471 AM -05:00
Can anyone suggest a way to retrieve the current timestamp from a remote DB
over DB Link?
---
Maris Elsins
@MarisElsins <https://twitter.com/MarisElsins>
www.facebook.com/maris.elsins
Other related posts:
