icon5.gif  BULK INSERT [message #402454] Sun, 10 May 2009 12:00 Go to next message
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: 10673
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.

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: 65090
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.

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

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 Jul 28 12:10:55 CDT 2017

Total time taken to generate the page: 0.05816 seconds