RE: SQLLDR and unrecoverable
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 4 Aug 2010 14:46:42 -0400
And, If I may interject myself in the conversation, why it should be the
default mode when ever you invoke archivelog. Caused me more trouble
than I ever cared to think of recently. Bother, squared.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark
Sent: Wednesday, August 04, 2010 2:41 PM
To: RStorey@xxxxxxxxxxxxxxxxxx; oracle-l-freelists
Subject: RE: SQLLDR and unrecoverable
Definitely. That'll do it.
In fact, that's specifically why FORCE LOGGING was introduced.
-Mark
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Storey, Robert (DCSO) [RStorey@xxxxxxxxxxxxxxxxxx]
Sent: Wednesday, August 04, 2010 14:26
To: oracle-l-freelists
Subject: RE: SQLLDR and unrecoverable
Hmm...a thought. I have a dataguard setup in place, which I'm pretty
sure required me to set FORCED LOGGING. Could this be overriding the
unrecoverable flag?
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Storey, Robert
(DCSO)
Sent: Wednesday, August 04, 2010 1:21 PM
To: oracle-l-freelists
Subject: SQLLDR and unrecoverable
I have a 9.2.0.8 database that I do some bulk loads in once a month.
Generally this is about 750,000 records.
I wrote a control file for sqlldr and all appears to work fine.
However, the issue is that it still generates redo even though I have
the unrecoverable option in it.
Here is the CTL file.
options (DIRECT=TRUE,ROWS=5000)
unrecoverable load data
infile 'c:\loadarrest\part1.txt'
truncate
into table dcsodba.jms_arrests
fields terminated by "," OPTIONALLY enclosed by '"'
(jms_number,
control_number,
admitted_date DATE "MM/DD/YYYY hh24:mi",
released_date DATE "MM/DD/YYYY hh24:mi",
warrant_number,
arrested_charge,
convicted_charge,
place_of_birth,
foreign_born,
blank_null,
suppress)
The data loads with no errors and it loads in about 15 or 20 secs. No
problem with the speed. But, today I checked and I noticed that I
generated about 3 or 4 archive logs when I ran the load (I only have
10meg logs.)
I execute the script in the directory where the infile is loaded. The
command I use is sqlldr control=loadarrest_ctl
I am then prompted for username and password and I enter those.
So, all things appear to work...accept that I generated redo. I checked
back a few months and realized I've always been generating it.
So, I'm stumped. This appears to be the correct format. What am I
missing?
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
