Re: Free/Shareware Data Mover?

Bill Petty wrote: [has been trimmed]
>
> I developed a handy little utility on the mainframe (not a dirty
> word),
> which copied data
> from one version of a table to another.
>
> Our new environment is VB4-WindowsNT /Oracle-AIX. Is anyone aware of
> such
> a utility in this environment? If you are, please post and/or E-mail.
>
> Thanks in advance.
>

What about using the copy command?

You can set up an SQL*Plus connection, remember to issue the set copycommit value for large tables to save the rollbacks, then
copy from <username/password_at_connect> -
to <username/password_at_connect> -
[append|create|insert|replace] -
<table name> using -
<query statement>

within the query statment you can use the string functions if necessary to alter the string sizes, or decodes to change the values, etc.

-adam Received on Fri Jun 20 1997 - 00:00:00 CDT