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

  • From: Robert Freeman <robertgfreeman@xxxxxxxxx>
  • To: mccdba1@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 5 May 2008 09:31:33 -0700 (PDT)

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


 Robert G. Freeman
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: (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
Fax: 508.229.2019 /
 Email: richard.goulet@xxxxxxxxxxxxx
45 Bartlett St. / Marlborough ,  MA   01752
Together: the Collaborative Business

From:oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of dba1 mcc
Sent: Monday, May 05, 2008 10:46
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.


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

Other related posts: