Home » SQL & PL/SQL » SQL & PL/SQL » BULK INSERT
icon5.gif  BULK INSERT [message #402454] Sun, 10 May 2009 12:00 Go to next message
jaytav001
Messages: 4
Registered: May 2009
Junior Member

hi friends... need help...

i am want to insert 500 million data from sTable to dTable such as

insert into dTable
select * from sTable

time taken : 20 mins
Note : there are no index or any constraint on both of thi tables.
database : oracle 10g

is there any fast way to insert bulk data ?
Re: BULK INSERT [message #402455 is a reply to message #402454] Sun, 10 May 2009 12:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Look int APPEND/Nologging/Parallel options.
These might help.
There are some other factors like hardware capabilities.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/transform.htm#sthref759

And
Search this forum.
There are too many topics on this.
Re: BULK INSERT [message #402456 is a reply to message #402454] Sun, 10 May 2009 12:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How to fast insert table topic a couple of days ago.
Please search before posting.

Regards
Michel
Re: BULK INSERT [message #402528 is a reply to message #402454] Mon, 11 May 2009 06:29 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Ummm...

By your own figures, you're getting about 400,000 rows a second inserting into the table.

What exactly qualifies as fast in your world, because that's pretty good performance from where I'm standing.
Previous Topic: Filtering data from SQL Resultset output [merged]
Next Topic: DECODE and CASE Expression Limitation (merged 3)
Goto Forum:
  


Current Time: Fri Dec 09 04:07:54 CST 2016

Total time taken to generate the page: 0.20459 seconds