java.sql.SQLException: ORA-

All posts relating to Oracle database administration.

Moderator: Tim...

java.sql.SQLException: ORA-

Postby royalyogi » Thu Jul 18, 2013 4:18 pm

Hi Tim,
Our application team are getting below error while running batch job. Please help me to resolve below error. I said them this below error is due to appliation end issue but they did not aggreed.Please through some light on this.

Error:
drop table SNK.I$_FLGS => java.sql.SQLException: ORA-00942: table or view does not exist
But less one second after :

create table SNK.I$_FLGS
(
ID_PAYS NUMBER(22) NULL,
ROB_EXT_FLGS NUMBER(22) NULL,
IND_UPDATE VARCHAR2(1)
) => java.sql.SQLException: ORA-00955: name is already used by an existing object
royalyogi
Senior Member
 
Posts: 167
Joined: Tue Apr 23, 2013 3:59 pm

Re: java.sql.SQLException: ORA-

Postby Tim... » Thu Jul 18, 2013 5:38 pm

Hi.

Certainly looks like an application issue to me... :)

Is it possible more than one process is trying to do the same thing at the same time? So when the second process comes to create the table it is already there?

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17950
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: java.sql.SQLException: ORA-

Postby royalyogi » Fri Jul 19, 2013 5:05 am

Thanks Tim, I know this is very bad practice to drop/recreate but ...
I got update from application team.

When they will relaunch the application, job will run successfully. But again they will get same error on another day.
Do you think, Can it privilege issue?please help me
royalyogi
Senior Member
 
Posts: 167
Joined: Tue Apr 23, 2013 3:59 pm

Re: java.sql.SQLException: ORA-

Postby Tim... » Fri Jul 19, 2013 7:01 am

Hi.

No. It is not a privilege issue. The fact it sometimes works proves this. If there were a privilege issue it would never work.

As far as I can see it is one of the following:

1) In a multi-user environment, more that one user is attempting to do the same thing at the same time, causing this issue.
2) Unknown to them, there code can sometimes fire the same command twice. So for example, the first drop works, the second fails with this error. The first create works, the second fails with this error.

This is most certainly an application issue, not a database issue. If they instrument their code properly, they will be able to see exactly what is happening when this fails.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17950
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 2 guests

cron