Oracle load error

kalpna · Post by **kalpna** » Thu Feb 16, 2006 12:40 pm

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

I_Server_Whale · Post by **I_Server_Whale** » Thu Feb 16, 2006 12:45 pm

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.

rasi · Post by **rasi** » Thu Feb 16, 2006 7:06 pm

kalpana

Is this happening in your development or Production environment?...

ray.wurlod · Post by **ray.wurlod** » Fri Feb 17, 2006 1:24 am

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.

kalpna · Post by **kalpna** » Fri Feb 17, 2006 4:17 am

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?'

kalpna · Post by **kalpna** » Fri Feb 17, 2006 4:40 am

And onther thing is ..
when i try to insert a row from sql prompt, i am successfull!!!

kalpna · Post by **kalpna** » Fri Feb 17, 2006 5:21 am

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