Re: Loging and No Log Data Base

: 100561.465@compuserve.com (Joe Quan) writes: : : Suppose you want to do : : insert into tablex... : select ... : from tabley : where ... : : tablex is in database X, and tabley is in database Y. : : You can create a synonym 'tabley' in the database X which links to the 'tabley' : in the database Y, or vice verse (RTFM). To your Window program (or be it a : character based program) , it only access one database ( X or Y). : : Better still, these two databases can be in two different instances and two : different servers. Of course, they can have different logging mode. This of course is the whole problem, they can't. Although the program itself access only one database the database server will have to connect to the other one, and that can't be done if they have different logging mode. (Altough I know of synonyms I haven't tested exactly this way of doing it. I only "know" i doesn't work from the manuals and other postings here.) Nils.Myklebust@ccmail.telemax.no NM-data, Dalsbergstien 7, N-0170 Oslo, Norway My opinions are those of my company