Re: Huge undotbs during insert

Sybrand Bakker wrote:
> On Sun, 29 May 2005 09:59:57 +0200, "astalavista" <spam_at_nowhere.com>
> wrote:
>
> >> Just a thought here, would the SQLPlus COPY command be of use in your
> >> scenario?
> >>
> >> Using COPY, you could do the following:
> >>
> >> SET COPYCOMMIT 1
> >> SET ARRAYSIZE 1000
> >> COPY FROM user/passwd_at_service APPEND table2 USING SELECT * FROM table1;
> >>
> >> where user/passwd is a valid logon to your database and service is a
> >> valid service name to connect via TNS.
> >>
> >> This would commit after every 1000 rows are inserted.
> >>
> >> Using the above syntax will insert rows if the table exists and create
> >> it and insert rows if it doesn't.
> >>
> >> I haven't used COPY extensively and I believe there MIGHT be issues
> >> with LONG columns, so that might be an issue for you. I have to say
> >> that I've no idea how the speed of COPY compares to other methods, so
> >> that might be another issue!
> >>
> >> Just a thought anyway.
> >
> >Thanks Tim , I will try COPY ...
> >
>
> COPY is a dead ally, as it is going to be desupported.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Indeed it is. But so what? It works with the release the OP is using and it may do the job he requires, so who cares really?

Regards,
Tim Kearsley
HBS Milton Keynes Received on Sun May 29 2005 - 07:50:53 CDT