Re: Transfer data from oracle to oracle using sqlplus only

G Quesnel wrote:
> 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 :(

No the process is not error prone. No editing of the data file is requred since only data and delimiters will exist in the spool file. Just FTP the spool from where it was created to where you want to read it. It is possible to generate the sqlldr control file from the source db. Most of the issues you can have with this method also exist if you try to copy data accross database links into existing structures.

HTH -- Mark D Powell -- Received on Fri Sep 01 2006 - 10:54:54 CDT