Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to find out the original SQL resulted the ERROR message?

How to find out the original SQL resulted the ERROR message?

From: zhu chao <zhuchao_at_gmail.com>
Date: Wed, 5 Oct 2005 18:50:17 +0800
Message-ID: <962cf44b0510050350o2848f7cemd066e48654a7d4e8@mail.gmail.com> 





Hi, All,



ORA-01555 caused by SQL statement below (SCN: 0x0314.01fa70b6):
Mon Oct 3 18:52:31 2005


SELECT /*+NESTED_TABLE_GET_REFS+*/ "FDBK_USER"."TRANSACT_RECORD".* FROM

"FDBK_USER"."TRANSACT_RECORD" where trx_type=1



--



Regards


Zhu Chao


www.cnoug.org <http://www.cnoug.org>



--



http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 05 2005 - 05:53:05 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US