The unfortunately soon to be deprecated 'copy' command. Works good for
medium data, uses copycommit and arraysize, and set long sqlplus
commands to control commiting. See sql reference guide for syntax.

Otherwise, external tables are coming on strong.... single statements or
not so much data.. as shown database links. If other database like DB2
etc. perhaps heterogeneous services. SQL*Server export/import (quick
easy -- but probably limited).

Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546

-----Original Message-----
From: JEFFERY
[mailto:oracledba-ezmlmshield-x70387237.[Email address protected]
Sent: Tuesday, October 31, 2006 3:52 PM
To: LazyDBA Discussion
Subject: RE: Write to remote customer database

Do you mean something similar to :

[At local DB] SQL> insert into table [Email Address Removed] (......);

Jeff


-----Original Message-----
From: oracledba-return-134275-JEFFERY.L.SCHRENK=saic.[Email address
protected]
[mailto:oracledba-return-134275-JEFFERY.L.SCHRENK=saic.[Email address
protected]
On Behalf Of David Chiu
Sent: Tuesday, October 31, 2006 12:35 PM
To: LazyDBA Discussion
Subject: Write to remote customer database



Like to hear any inputs/suggestions of a good solution using oracle to
write to a remote customer database?


------------------------------------------------------------------------
----
David Chiu



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page