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