How to select sysdate of remote database
I want to fetch the sysdate of a remote database using dblink, I used the following sql :
select sysdate from dual@remote_db_link
But this fetches me local server date and not of the remote one.
Is there a sql to do this, since i can't write procedures in each remote machines which will be called by local sever to do the same task.
Thanks
Re: How to select sysdate of remote database
Quote:
Originally posted by send2sachin
I want to fetch the sysdate of a remote database using dblink, I used the following sql :
select sysdate from dual@remote_db_link
But this fetches me local server date and not of the remote one.
Is there a sql to do this, since i can't write procedures in each remote machines which will be called by local sever to do the same task.
Thanks
Darn! This question seemed so trivial at first, yet I have spend couple of hours searching for an answer with no luck! It seems to me that there realy is no other way but to create a function or a view on remote database to get the sysdate of that database over db link.
If anyone finds a direct way to get a remote sysdate without creating any additional object on a remote database, I'd be very interested.