Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> simple sqlldr control file

simple sqlldr control file

From: <landrewolsen_at_gmail.com>
Date: 19 Oct 2005 11:50:03 -0700
Message-ID: <1129747803.351719.306460@g14g2000cwa.googlegroups.com>


OPTIONS (ERRORS=50000000, DIRECT=true, ROWS=1000000) LOAD DATA
APPEND INTO TABLE OBJECT_DATA
FIELDS TERMINATED BY '|'
(
  OBJECT_ID CHAR,
  PART_ID CHAR,
  DATA CHAR(2000)
) Received on Wed Oct 19 2005 - 13:50:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US