CODEWITHSUNDEEP
databaseoracle-databaseora-12170
Only a Curious Mind
Only a Curious Mind

Reputation: 2857

What is the Oracle error code (ORA-) for a Query Timeout?

I need to know whats the oracle QUERY timeout error code.

I know the code ORA-12170, but this code is an TNS connect timeout. I need the Query timeout.

I looked in many places and not find the answer.

Upvotes: 0

Views: 2002

Answers (2)

eliatou
eliatou

Reputation: 744

I'm not agree with you. When you hit an ORA-01013, it's because you have no more temp space to execute your query.

ORA-01555: snapshot too old is more appropriate. It's caused by Oracle read consistency mechanism.

Upvotes: 1

Rahul Tripathi
Rahul Tripathi

Reputation: 172628

ORA-01013 - user requested cancel of current operation

This is the message and code which you will get when the timeout happens.

Upvotes: 2

Related Questions