Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Copy a record from 1-table to another
TOAD won't work because this will have to run in the middle of the
night from a shell script.
I can't see how the first part of this response is will solve the
problem.
I have data in one table that all I want to do is move to another table
and add 3-additional fields.
Perhaps bulk collect/insert will work, but I have been unable to make
it work given the documentation and examples I have found so far.
Thanks anyway.
Joe
Sybrand Bakker wrote:
> On 14 Dec 2005 14:43:47 -0800, "JoeT" <trubisz_at_yahoo.com> wrote:
>
> >All I want to do is copy R (which is over 200 attributes) to S which is
> >the same structure with 3-additional attributes, and populate the
> >3-attributes when I do this.
>
> And this requires only a little cutting and pasting...
>
> just
> spool x
> desc r
> spool off
> edit x and transform it into s
> OR
> Use Toad, select all columns, right click and generate an INSERT
> statement.
> Your solution is a *disaster* in terms of performance as you are
> fetching record for record. You would at least need to do a BULK
> COLLECT and BULK INSERT,
> and coding that is WAY MORE WORK than
> INSERT SELECT
>
> Geeez, don't people learn to WORK anymore nowadays?
> It sure looks like!!
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Wed Dec 14 2005 - 20:59:41 CST