Re: [Q] ORACLE support bilk insert like SQL server??

Also look at data pump import. It supports direct path load. A huge advantage 
over imp.
Of course, this won't help you load non-Oracle data... :-)

RF


 Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle  (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)



----- Original Message ----
From: "Goulet, Dick" <richard.goulet@xxxxxxxxxxxxx>
To: mccdba1@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Sent: Monday, May 5, 2008 9:21:14 AM
Subject: RE: [Q] ORACLE support bilk insert like SQL server??

 
In Pro*C look under Array Processing.
 
In PL/SQL look under Bulk Collect
 
In SQL*Loader look under columnarrayrows
and direct path load
 
______________________________________________________________
Dick Goulet / Capgemini
North AmericaP&C / East Business Unit
Senior Oracle DBA / Hosting
Office: 508.573.1978 / Mobile : 508.742.5795
/ www.capgemini.com
Fax: 508.229.2019 /
 Email: richard.goulet@xxxxxxxxxxxxx
45 Bartlett St. / Marlborough ,  MA   01752
Together: the Collaborative Business
Experience 
______________________________________________________________

________________________________
 
From:oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of dba1 mcc
Sent: Monday, May 05, 2008 10:46
AM
To: oracle-l@xxxxxxxxxxxxx
Subject: [Q] ORACLE support bilk
insert like SQL server??
 
Does any version of ORACLE support "bulk insert" like SQL
server?  I search on Google and can NOT find any info.

Thanks.
  

________________________________
 
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try
it now.

Other related posts: