This forum is currently locked. You can't register or post questions at this time. (read more)

java.sql.SQLException: ORA-

All posts relating to Oracle database administration.

Moderator: Tim...

royalyogi
Senior Member
Posts: 181
Joined: Tue Apr 23, 2013 3:59 pm

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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

royalyogi
Senior Member
Posts: 181
Joined: Tue Apr 23, 2013 3:59 pm

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests

cron