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

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Mon, 5 May 2008 09:31:33 -0700 (PDT)
Message-ID: <155159.15708.qm@web38905.mail.mud.yahoo.com>

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_at_capgemini.com> To: mccdba1_at_yahoo.com; oracle-l_at_freelists.org 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_at_capgemini.com
45 Bartlett St. / Marlborough , MA 01752 Together: the Collaborative Business
Experience

---

---

 

From:oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Monday, May 05, 2008 10:46
AM
To: oracle-l_at_freelists.org
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.

--
http://www.freelists.org/webpage/oracle-l

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