Oracle-L: RE: Data Transfer between two instances

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Mon, 20 Oct 2003 10:49:26 -0800
Message-ID: <F001.005D3C25.20031020104926@fatcity.com>

On the application which needs the data,can you use CTAS with nologging? This is a pretty fast way of transfering data. Have you investigated transportable tablespaces. How current does the data have to be?

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu <mailto:ian_at_SLAC.Stanford.edu>

-----Original Message-----
Sent: Sunday, October 19, 2003 10:39 PM
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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU

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). Received on Mon Oct 20 2003 - 13:49:26 CDT