Joel,
Thanks for the suggestion. I did broach the idea of running some
separate appliation (java/perl whatever) on the remote side to extract
and FTP but it got shot down. Of course by 16 hour updates may repair
those bullet holes<G>.
Joel Garry wrote:
> Can you CTAS on the remote site to make a table of what you want,
> select it into a file, ftp over and sqlload? That's not actually
> changing anything, but does require more than select privs. What you
> gain is minimizing sqlnet interaction with the frame relay, ftp can be
> repeated until it works. Even better if you can talk them into an sp
> that you just have to fire off, that might be more PC if they feel
> they have control over sp's.
>
> Sometimes the way to deal with dumb old versions is with dumb old
> tools.
>
> jg
> --
> @home.com is bogus.
> http://www.technologyreview.com/blog/blog.asp?byCat=1
Received on Fri Jul 16 2004 - 17:26:59 CDT
