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

From: Robert Freeman <>
Date: Mon, 5 May 2008 09:31:33 -0700 (PDT)
Message-ID: <>

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" <> To:; 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 /
45 Bartlett St. / Marlborough , MA 01752 Together: the Collaborative Business
Experience [] On Behalf Of dba1 mcc Sent: Monday, May 05, 2008 10:46
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.

Received on Mon May 05 2008 - 11:31:33 CDT

Original text of this message