Re: Accessing logging DD from non-logging

Jon C. Vemo (jvemo@cyberspace.com) wrote: : I have a non-logging database. I am building a new logging database, which : will reside under a seperate instance of OL, on a different machine. I want : to be able to access data residing under one of the instances, from the : other. At this point I don't believe it will matter which instance (logging : or non) I am accessing from, just that I be able to query for data on the : other. Can this be done?? Jon, if you want to access a remote database table with the <database@server:"owner".tablename> syntax, the logging mode on both databases must be the same (even buffered vs. unbuffered logging won't work). I've stumbled across this problem numerous times, and always felt very annoyed by it. There must be a good reason for this, so I guess we just have to take it like it is. Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+