|
|
Oracle Database 10.2.0.5
Hello Erman,
I am getting the error below:
SELECT rtrim(t.transaction_set_id)||'|'||
to_char(t.trans_id)||'|'||
rtrim(t.buyer_id)||'|'||
rtrim(t.vendor_id)||'|'||
rtrim(to_char(T.RECORD_DATE, 'DD/MM/YYYY HH24:MI:SS'))||'|'||
rtrim(T.LABEL)||'|'||
rtrim(T.DISPATCH_CODE1)||'|'||
rtrim(T.DISPATCH_CODE2)||'|'||
rtrim(regexp_replace(T.DISPATCH_CODE3,'\|*',''))||'|'||
rtrim(t.offer_code)||'|'||
rtrim(t.subscription_code)||'|'||
to_char(T.amount)||'|'||
to_char(t.TAX_AMOUNT)||'|'||
to_char(t.correction_status)||'|'||
to_char(t.origin)||'|'||
to_char(t.tax_status)||'|'||
to_char(Max(DECODE(td.name,'U.vol_total',td.number_value,'U.total_volume',td.number_value)))||'|'||
rtrim(MAX(DECODE(td.name,'I.called_num_disp',td.string_value)))||'|'||
rtrim(max(decode(td.name,'U.invoice_label',td.string_value)))||'|'||
rtrim(max(decode(td.name,'U.destination_label',td.string_value)))||'|'||
rtrim(max(decode(td.name,'U.destination_type',td.string_value)))||'|'||
to_char(MAX(DECODE(td.name,'I.call_duration',td.number_value)))||'|'
FROM transac_detail partition(P20161003) td INNER JOIN transac partition(P20161003) t ON td.trans_id = t.trans_id
WHERE t.vendor_id = 'MT_CO'
group by t.transaction_set_id,t.trans_id,t.buyer_id,t.vendor_id, T.RECORD_DATE, t.LABEL,t.dispatch_code1,t.dispatch_code2,t.dispatch_code3,t.amount,t.TAX_AMOUNT,
t.offer_code,t.subscription_code,t.ORIGIN,t.correction_status,t.tax_status;
find below the error message
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []
00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
*Cause: This is the generic internal error number for Oracle program
exceptions. It indicates that a process has encountered a low-level,
unexpected condition. The first argument is the internal message
number. This argument and the database version number are critical in
identifying the root cause and the potential impact to your system.
and the connection to the database has been lost.
I have checked the alert log. It says:
ORA-01555 caused by SQL statement below (SQL ID: 7mbuy20umxgfy, Query Duration=24 sec, SCN: 0x001f.e0406c42):
Thu Nov 03 05:41:28 MUT 2016
select u.name, o.name from obj$ o,user$ u, (select obj# objnum# from tab$ where ts#=:1 and bitand(property,64+512+8192)=0 union all select distinct t.obj# objnum# from tabpart$ tp,tab$ t where tp.ts#=:1 and t.obj#=tp.bo# and bitand(property,64+512+8192)=0 union all select distinct t.obj# objnum# from tabcompart$ tcp,tabsubpart$ tsp,tab$ t where tsp.ts#=:1 and tsp.pobj#=tcp.obj# and t.obj#=tcp.bo# and bitand(property,64+512+8192)=0 union all select t.obj# objnum# from ind$ i,tab$ t where i.ts#=:1 and i.type#=4 and t.obj#=i.bo# and bitand(t.property,8192)=0 union all select distinct t.obj# objnum# from indpart$ ip,ind$ i,tab$ t where ip.ts#=:1 and i.type#=4 and i.obj#=ip.bo# and t.obj#=i.bo# and bitand(t.property,8192)=0 union all select distinct t.obj# objnum# from indcompart$ icp,indsubpart$ isp,ind$ i,tab$ t where isp.ts#=:1 and i.type#=4 and isp.pobj#=icp.obj# and i.obj#=icp.bo# and
ORA-604 signalled during: DROP TABLESPACE HD_283112519034_20160804_1 INCLUDING CONTENTS...
Thu Nov 03 08:09:14 MUT 2016
Thread 1 advanced to log sequence 12281 (LGWR switch)
Current log# 8 seq# 12281 mem# 0: /data/ora/PMTBIL01/u01/redo8ardo
Current log# 8 seq# 12281 mem# 1: /redo/PMTBIL01/redo8brdo
Thu Nov 03 08:39:47 MUT 2016
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=85, OS id=13022
to execute - SYS.KUPM$MCP.MAIN('JOBDP_HD_283112519034_20160804', 'HDBUSR', 'KUPC$C_1_20161103083947', 'KUPC$S_1_20161103083947', 0);
kupprdp: worker process DW01 started with worker id=1, pid=86, OS id=13032
to execute - SYS.KUPW$WORKER.MAIN('JOBDP_HD_283112519034_20160804', 'HDBUSR');
Thu Nov 03 08:41:29 MUT 2016
DROP TABLESPACE HD_283112519034_20160804_1 INCLUDING CONTENTS
Thu Nov 03 08:42:21 MUT 2016
Starting control autobackup
Control autobackup written to DISK device
handle '/exec/products/oracle/v10.2/dbs/c-483556544-20161103-04'
Completed: DROP TABLESPACE HD_283112519034_20160804_1 INCLUDING CONTENTS
Thu Nov 03 09:16:07 MUT 2016
Errors in file /exec/products/oracle/v10.2/admin/PMTBIL01/udump/pmtbil01_ora_6933.trc:
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [
Regards,
Roshan
|
Locked
