Re: Copy a record from 1-table to another

Care to share how easy the script is?
Nobody has come up with a reasonable solution so far.

Joe

Jim Kennedy wrote:
> "JoeT" <trubisz_at_yahoo.com> wrote in message
> news:1134615581.507689.266780_at_g43g2000cwa.googlegroups.com...
> > 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
> >

>