Home » SQL & PL/SQL » SQL & PL/SQL » insert into
insert into [message #188629] Mon, 21 August 2006 01:44 Go to next message
steffeli
Messages: 112
Registered: July 2006
Senior Member
Hello

I have five tables with the same field structure and several billion records each. Now I want to union these tables into a new result-table.
So far, I insert the records of each table into the new result table with "insert into". Unfortunately, this is very slow. Is there a faster way to do this?

Thanks
Stefan
Re: insert into [message #188635 is a reply to message #188629] Mon, 21 August 2006 02:01 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
CREATE TABLE big_un 
PARALLEL 
AS
SELECT *
FROM big_un1
UNION ALL
SELECT *
FROM big_un2


Ross Leishman
Re: insert into [message #188645 is a reply to message #188635] Mon, 21 August 2006 02:19 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Can you disable Logging with parallel inserts?
If so, that would speed things up too.
Previous Topic: XML elements to table columns
Next Topic: data type issue
Goto Forum:
  


Current Time: Sat Dec 03 04:02:31 CST 2016

Total time taken to generate the page: 0.10041 seconds