SAP runs on Oracle. Unless you use that cheap thing that MYSql currently offers, in which case use heterogeneous services, if you can find the odbc driver. Then a DB Link or the COPY command will work.
Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- Sent: Monday, October 20, 2003 8:37 AM To: Multiple recipients of list ORACLE-L Iz SAP DB Oracle?? On 2003.10.20 07:34, "Goulet, Dick" wrote: > Have you tried SQL*Plus's COPY command?? > > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -----Original Message----- > Sent: Monday, October 20, 2003 1:39 AM > To: Multiple recipients of list ORACLE-L > > > Hi all, > > we have an application which needs data from other environment (which is > actually SAP db). Currently we have implemented it the way we create flat > files and put them in using pl/sql -procedures but I don't like this because > the data in the flat files are "visible" and it is somehow "secret". > > What other options we might have if we do not want to use db links (because > of its slowness. > > I very much appreciate all your suggestions... > > TIA > gb > > > > _____ > > Want to chat instantly with your online friends? > <http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.com/ > > > Get the FREE Yahoo! Messenger > > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).