Problem using Sql Load with Oracle Enterprise stage

[Inquisitive]

Hi,

I am trying to load a table with Oracle enterprise stage using LOAD option.

But I am getting following error.

Oracle_Enterprise_10,0: Call to sqlldr failed. Return code = 256Please see loader logfile: C:/Ascential/DataStage/Scratch/ora.4132.640000.0.log for details.


Below is the entry of the log file.

SQL*Loader: Release 10.1.0.2.0 - Production on Sun Sep 3 23:35:35 2006

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Control File: ora.4132.640000.0.ctl
Character Set WE8ISO8859P1 specified for all input.

Data File: \\.\pipe\ora.4132.640000.fifo.0
File processing option string: "FIX 25"
Bad File: ora.4132.640000.0.log.bad
Discard File: none specified

(Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Continuation: none specified
Path used: Direct - with parallel option.

Table STATUS, loaded from every logical record.
Insert option in effect for this table: APPEND

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
STATUS_TYPE 1:4 4 INTEGER
DESCRIPTION 5:24 20 CHARACTER
NULL if DESCRIPTION = BLANKS

SQL*Loader-951: Error calling once/load initialization
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified

Please let me know if you have any solution for this.

Thanks

[kcbland]

The table or partitions being loaded have some exclusive lock on them. Maybe there's an open SELECT processing or a previous INSERT/UPDATE/DELETE/TRUNCATE command is still processing.

You'll have to get a DBA to look at the situation with the table. DIRECT path requires exclusive access to a table or partitions.

[chulett]

ORA-00054: resource busy and acquire with NOWAIT specified

The table is in use and you need to figure out why. Could be as simple as you being parked in it in TOAD... not that I've ever done that before.

[xinhuang66]

Is it possible that there are some process in the job itself cause the lock ?

Usually the case happens when doing sql loader with default options, by using new options (direct=false), will ask sql*Loader wait for lock release .

Any more thoughts or updates ?

[chulett]

Is it possible that there are some process in the job itself cause the lock ?

Nope. It really is as simple as already posted. And the rules for a direct path versus a conventional load are different.