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

  • From: zhu chao <zhuchao@xxxxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 5 Oct 2005 18:50:17 +0800

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>

Other related posts: