Re: Getting sysdate across a DB link

On 28 Feb 2003, paul.moore_at_atosorigin.com wrote:

> As a simplified version of my problem, suppose I want to calculate the
> clock difference between the local and remote machines. The "obvious"
> approach is
>
> select l.sysdate - r.sysdate from dual l, dual_at_remote_db r;
>
> This doesn't work - it gives me an error "ORA-01747: invalid
> user.table.column, table.column, or column specification" (presumably
> because SYSDATE is a date function, not a column).

Does your database link allow you access to any other objects, ie, are you sure that retrieving remote sysdate is the issue?

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.