Re: Transfer data from oracle to oracle using sqlplus only

What accuracy rate are you expecting/commiting to ? What happens if one of the values is larger then 80 or 1000 characters wide.

So the manual way you are looking at is to:
- spool the result to a file,

• define every column in a format that guaranties no loss of data (ex: col amt_due format 99999999999999999.9999999)
• define your sqlplus environment (pagesize 0, linesize 999,feedback off ....)
• Select * from some_table where some_condition ...
• spool off
• edit spooled file, copy data
• edit local file, paste data
• declare external table, using SQL Loader structure

This seems very error prone ...
And there are no possibility of somebody doing an export (with where clause on specific tables), and emailing you the dump files ? Too bad :( Received on Wed Aug 30 2006 - 12:25:07 CDT