Home » SQL & PL/SQL » SQL & PL/SQL » same version of DB, different query results. (Oracle , 10.2.0.3.0, TNS for IBM/AIX RISC System/6000)
same version of DB, different query results. [message #429050] Sun, 01 November 2009 19:14 Go to next message
kang
Messages: 89
Registered: November 2007
Member
select ltrim(max(sys_connect_by_path(plc_nm, ', ')), ', ') plc_nm
  from (select plc_nm,
                row_number() over(order by regexp_replace(PLC_NM, '[url=http://www.orafaq.com/wiki/:space:]:space:[/url]', '')) rnum
           from (
                 select distinct *
                   from (
                          SELECT a.PLC_NM,
                                  a.busi_deal_no
                            FROM TB_USE_PLC           a,
                                  tb_seal_ri_prms_detl s
                           where a.use_plc_seq = s.use_plc_seq
                             and s.busi_deal_no(+) = '10'
                             and s.busi_detl_seq(+) = '1'
                          union all
                          SELECT a.PLC_NM,
                                 a.busi_deal_no
                            FROM TB_USE_PLC             a,
                                 tb_unseal_ri_prms_detl s
                           where a.use_plc_seq = s.use_plc_seq
                             and s.busi_deal_no(+) = '10'
                             and s.busi_detl_seq(+) = '1'
                          union all
                          SELECT a.PLC_NM,
                                 a.busi_deal_no
                            FROM TB_USE_PLC      a,
                                 tb_rg_prms_detl s
                           where a.use_plc_seq = s.use_plc_seq
                             and s.busi_deal_no(+) = '10'
                             and s.busi_detl_seq(+) = '1'
                          )
                  ORDER BY REGEXP_REPLACE(PLC_NM, '[url=http://www.orafaq.com/wiki/:space:]:space:[/url]', '')))
 start with rnum = 1
connect by prior rnum = rnum - 1


ORA-03113: end-of-file on communication channel

the versions of two databases are exactly the same.
select * from v$version;
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Productio
NLSRTL Version 10.2.0.3.0 - Production

why one database complains ora-03113?
my client tool is pl/sql developer 7.1.
Re: same version of DB, different query results. [message #429051 is a reply to message #429050] Sun, 01 November 2009 19:40 Go to previous messageGo to next message
BlackSwan
Messages: 24915
Registered: January 2009
Senior Member
>why one database complains ora-03113?
It might be a data dependent bug.

Usually a trace file is generated by ORA-03113
It might contain clues.

Re: same version of DB, different query results. [message #429064 is a reply to message #429050] Sun, 01 November 2009 23:27 Go to previous message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 are generic errors for Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel
Previous Topic: Unable to compile
Next Topic: Rank in query
Goto Forum:
  


Current Time: Sat Oct 01 09:14:16 CDT 2016

Total time taken to generate the page: 0.08735 seconds