Re: [Q] ORACLE support bilk insert like SQL server??
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx, "Goulet, Dick" <richard.goulet@xxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 5 May 2008 09:55:17 -0700 (PDT)
perhaps an external table is what you are wanting?? Then the insert statement
could use an append hint.
Say you had an external file called X. You can create an external table (9i and
later) that allows you to access that external file from the database like a
database table. This is called an external table. Call this table TAB_X.
You could then use an insert /*+ APPEND */ command to use direct mode to read
the external table data and import it into the database:
insert /*+ APPEND */ into NEW_TAB select * from TAB_X.
Is this what you are wanting?
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: dba1 mcc <mccdba1@xxxxxxxxx>
To: "Goulet, Dick" <richard.goulet@xxxxxxxxxxxxx>; oracle-l@xxxxxxxxxxxxx
Sent: Monday, May 5, 2008 9:48:52 AM
Subject: RE: [Q] ORACLE support bilk insert like SQL server??
What I want is use "insert" statement read "external file" NOT PL/SQL or
SQl*Loader.
"Goulet, Dick" <richard.goulet@xxxxxxxxxxxxx> wrote:
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.
________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
Other related posts:
