Have
you tried SQL*Plus's COPY command??
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i
DBA
-----Original Message-----
From: Gunnar Berglund [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 1:39 AM
To: Multiple recipients of list ORACLE-L
Subject: Data Transfer between two instancesHi 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...TIAgb
Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger
