Path: news.easynews.com!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!diablo.theplanet.net!news.indigo.ie!not-for-mail Reply-To: "Telemachus" From: "Telemachus" Newsgroups: comp.databases.oracle.server References: <182bcf76.0302280853.71aed8f0@posting.google.com> <8IM7a.12457$V6.16915@news.indigo.ie> Subject: Re: Getting sysdate across a DB link Lines: 25 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: Date: Mon, 3 Mar 2003 10:28:02 -0000 NNTP-Posting-Host: 62.77.170.89 X-Complaints-To: abuse@eircom.net X-Trace: news.indigo.ie 1046688042 62.77.170.89 (Mon, 03 Mar 2003 10:40:42 GMT) NNTP-Posting-Date: Mon, 03 Mar 2003 10:40:42 GMT Organization: Eircom.Net http://www.eircom.net Xref: newsfeed1.easynews.com comp.databases.oracle.server:178239 X-Received-Date: Mon, 03 Mar 2003 03:40:36 MST (news.easynews.com) Yes I did ... but why not create a tiny view in a schema that you can reference ? "Paul Moore" wrote in message news:u1eo9g8m.fsf@morpheus.demon.co.uk... > "Telemachus" writes: > > > it works with full views - but my clocks are synchronized so your mileage > > may vary. > > SQL> CREATE VIEW MOO AS SELECT 1 AS SILLY_HEADER,SYSDATE AS MOOTIME FROM > > DUAL; > > > > View created. > > Did you need to create that view on the remote server? If so, having a > view on the remote server is just as much (or as little, depending on > how you look at it...) of a problem as defining a function on the > remote server. > > Thanks for the suggestion, > Paul. > -- > This signature intentionally left blank