Home » SQL & PL/SQL » SQL & PL/SQL » ora-03114 error
ora-03114 error [message #254033] Wed, 25 July 2007 10:26 Go to next message
ammishra
Messages: 179
Registered: January 2007
Location: india
Senior Member
Hi,

This is some thing odd but i have tested 4-5 times. when
i am running following query I will get the result.

Select distinct LAST_UPDATE_DATE from ERP_AVP_TRANSACTIONS

this query has returned just 856 records..

But when i am running following query

Select distinct LAST_UPDATE_DATE from ERP_AVP_TRANSACTIONS order by LAST_UPDATE_DATE desc

i got ora-03114 error. when ever I am running second query my connection got break.might be it is just a chance but I have tested 5-6 times..

--Yash
Re: ora-03114 error [message #254034 is a reply to message #254033] Wed, 25 July 2007 10:27 Go to previous message
ammishra
Messages: 179
Registered: January 2007
Location: india
Senior Member
plz fine the same in formatted manner

Hi,

This is some thing odd but i have tested 4-5 times. when
i am running following query I will get the result.

Select distinct LAST_UPDATE_DATE from ERP_AVP_TRANSACTIONS
this query has returned just 856 records..

But when i am running following query

Select distinct LAST_UPDATE_DATE from ERP_AVP_TRANSACTIONS order by LAST_UPDATE_DATE desc  


i got ora-03114 error. when ever I am running second query my connection got break.might be it is just a chance but I have tested 5-6 times..

--Yash

Previous Topic: ORA-22905: cannot access rows from a non-nested table item
Next Topic: EXCHANGE PARTITION
Goto Forum:
  


Current Time: Wed Dec 07 12:52:38 CST 2016

Total time taken to generate the page: 0.05631 seconds