Page 1 of 1
Oracle load error
Posted: Thu Feb 16, 2006 12:40 pm
by kalpna
Hi Friends
I got this error while loading to Oracle table.
ADatabaseLoad..TargetDBase: ORA-00054: resource busy and acquire with NOWAIT specified
does it mean that, there is a lock on target database?
Any clue???
Kalpna
Posted: Thu Feb 16, 2006 12:45 pm
by I_Server_Whale
Hi kalpna,
ORA-00054: resource busy and acquire with NOWAIT specified
Cause: The NOWAIT keyword forced a return to the command prompt because a resource was unavailable for a LOCK TABLE or SELECT FOR UPDATE command.
Action: Try the command after a few minutes or enter the command without the NOWAIT keyword.
Thanks,
Naveen.
Posted: Thu Feb 16, 2006 7:06 pm
by rasi
kalpana
Is this happening in your development or Production environment?...
Posted: Fri Feb 17, 2006 1:24 am
by ray.wurlod
Clearly that's not something we can diagnose. There's something happening in your Oracle instance that is preventing another client (your DataStage job) from doing what it wants to do. Talk with your Oracle DBA about what it might be.
Posted: Fri Feb 17, 2006 4:17 am
by kalpna
Hello!! Everyone
Yes!..I think its not a datastage issue.
But,I am writing the same output to sequential file and Oracle.
I failed to understand one thing that,'Y is it not loading to sequential file,if it is a database issue?'
Posted: Fri Feb 17, 2006 4:40 am
by kalpna
And onther thing is ..
when i try to insert a row from sql prompt, i am successfull!!!
Posted: Fri Feb 17, 2006 5:21 am
by kalpna
Hi! Naveen
Sorry! I didn't get you..
in my job, Iam using a oracle stage as my target with truncate and insert option...
siva!..
its in development...
Kalpana