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
Problem using Sql Load with Oracle Enterprise stage
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 88
- Joined: Tue Jan 13, 2004 3:07 pm
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.
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Re: Problem using Sql Load with Oracle Enterprise stage
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.Inquisitive wrote:ORA-00054: resource busy and acquire with NOWAIT specified
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 161
- Joined: Wed Aug 02, 2006 4:30 am