Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Huge undotbs during insert
> 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 ... Received on Sun May 29 2005 - 02:59:57 CDT