Re: sqlldr ignores skip
Date: Fri, 8 May 2009 03:17:05 -0700 (PDT)
On May 8, 5:13 am, Thomas Poenicke <poeni..._at_freenet.de> wrote:
> > Which release of Oracle are you using? Without that information it's
> > practically impossible to solve your problem.
> > David Fitzjarrell
> Hi David,
> here is the Version Information:
> Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
> PL/SQL Release 10.2.0.1.0 - Production
> CORE 10.2.0.1.0 Production
> TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
> NLSRTL Version 10.2.0.1.0 - Production
> Maybe the reason is the Express Edition.
The 10.2.0.1 is missing a lot of maintenance patching up to 10.2.0.4 might fix ... possibly?
I don't think you are "supposed to be able to" patch XE but some people have reported that it is possible under at least some circumstances? Maybe there is an 11g version of XE that works perhaps with SKIP?
To bypass your problem how about passing your input thru some kind of utility/procedure that ditches the records you don't want to load before it hits sqlldr. Received on Fri May 08 2009 - 05:17:05 CDT