RE: Data Transfer between two instances

[MacGregor, Ian A.]

Title: Message

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

[EMAIL PROTECTED]

-----Original Message-----
From: Gunnar Berglund [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 19, 2003 10:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Data Transfer between two instances

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? Get the FREE Yahoo! Messenger