RE: Data Transfer between two instances

Jared,

        Correction, "was". Hasn't been updated in several years as I understand. That's why they farmed it out to MySql recently.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
Sent: Tuesday, October 21, 2003 12:54 AM To: Multiple recipients of list ORACLE-L

Actually, that 'cheap thing' is SAP DB, which is a simply what SAP renamed Adabas when they purchased it. Apparently it is quite a capable databas.

On Mon, 2003-10-20 at 05:59, Goulet, Dick wrote:
> 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: mgogala_at_adelphia.net
>
> 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: ListGuru_at_fatcity.com (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: DGoulet_at_vicr.com
>
> 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: ListGuru_at_fatcity.com (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: Jared Still
  INET: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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: DGoulet_at_vicr.com

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: ListGuru_at_fatcity.com (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).