我当时也遇到这个错误了没有解决只是避免了
表结构
dm_user.DM_FINANC
CREATE TABLE "DM_USER"."DM_FINANC"
( "STATISTICS" DATE,
"ORGAN_CODE" CHAR(8),
"CURRENCY_CODE" CHAR(2),
"ACCT_CODE" CHAR(12),
"ARTICLE_CODE" CHAR(8),
"ITEM_BALANCE" NUMBER(16,3)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOLOGGING
STORAGE(
BUFFER_POOL DEFAULT)
TABLESPACE "DW01"
PARTITION BY HASH ("ACCT_CODE")
(PARTITION "SYS_P133394"
TABLESPACE "DW01",
PARTITION "SYS_P133395"
TABLESPACE "DW01",
PARTITION "SYS_P133396"
TABLESPACE "DW01",
PARTITION "SYS_P133397"
TABLESPACE "DW01",
PARTITION "SYS_P133398"
TABLESPACE "DW01",
PARTITION "SYS_P133399"
TABLESPACE "DW01",
PARTITION "SYS_P133400"
TABLESPACE "DW01",
PARTITION "SYS_P133401"
TABLESPACE "DW01",
PARTITION "SYS_P133402"
TABLESPACE "DW01",
PARTITION "SYS_P133403"
TABLESPACE "DW01",
PARTITION "SYS_P133404"
TABLESPACE "DW01",
PARTITION "SYS_P133405"
TABLESPACE "DW01",
PARTITION "SYS_P133406"
TABLESPACE "DW01",
PARTITION "SYS_P133407"
TABLESPACE "DW01",
PARTITION "SYS_P133408"
TABLESPACE "DW01",
PARTITION "SYS_P133409"
TABLESPACE "DW01",
PARTITION "SYS_P133410"
TABLESPACE "DW01",
PARTITION "SYS_P133411"
TABLESPACE "DW01",
PARTITION "SYS_P133412"
TABLESPACE "DW01",
PARTITION "SYS_P133413"
TABLESPACE "DW01",
PARTITION "SYS_P133414"
TABLESPACE "DW01",
PARTITION "SYS_P133415"
TABLESPACE "DW01",
PARTITION "SYS_P133416"
TABLESPACE "DW01",
PARTITION "SYS_P133417"
TABLESPACE "DW01",
PARTITION "SYS_P133418"
TABLESPACE "DW01",
PARTITION "SYS_P133419"
TABLESPACE "DW01",
PARTITION "SYS_P133420"
TABLESPACE "DW01",
PARTITION "SYS_P133421"
TABLESPACE "DW01",
PARTITION "SYS_P133422"
TABLESPACE "DW01",
PARTITION "SYS_P133423"
TABLESPACE "DW01",
PARTITION "SYS_P133424"
TABLESPACE "DW01",
PARTITION "SYS_P133425"
TABLESPACE "DW01",
PARTITION "SYS_P133426"
TABLESPACE "DW01",
PARTITION "SYS_P133427"
TABLESPACE "DW01",
PARTITION "SYS_P133428"
TABLESPACE "DW01",
PARTITION "SYS_P133429"
TABLESPACE "DW01",
PARTITION "SYS_P133430"
TABLESPACE "DW01",
PARTITION "SYS_P133431"
TABLESPACE "DW01",
PARTITION "SYS_P133432"
TABLESPACE "DW01",
PARTITION "SYS_P133433"
TABLESPACE "DW01",
PARTITION "SYS_P133434"
TABLESPACE "DW01",
PARTITION "SYS_P133435"
TABLESPACE "DW01",
PARTITION "SYS_P133436"
TABLESPACE "DW01",
PARTITION "SYS_P133437"
TABLESPACE "DW01",
PARTITION "SYS_P133438"
TABLESPACE "DW01",
PARTITION "SYS_P133439"
TABLESPACE "DW01",
PARTITION "SYS_P133440"
TABLESPACE "DW01",
PARTITION "SYS_P133441"
TABLESPACE "DW01",
PARTITION "SYS_P133442"
TABLESPACE "DW01",
PARTITION "SYS_P133443"
TABLESPACE "DW01",
PARTITION "SYS_P133444"
TABLESPACE "DW01",
PARTITION "SYS_P133445"
TABLESPACE "DW01",
PARTITION "SYS_P133446"
TABLESPACE "DW01",
PARTITION "SYS_P133447"
TABLESPACE "DW01",
PARTITION "SYS_P133448"
TABLESPACE "DW01",
PARTITION "SYS_P133449"
TABLESPACE "DW01",
PARTITION "SYS_P133450"
TABLESPACE "DW01",
PARTITION "SYS_P133451"
TABLESPACE "DW01",
PARTITION "SYS_P133452"
TABLESPACE "DW01",
PARTITION "SYS_P133453"
TABLESPACE "DW01",
PARTITION "SYS_P133454"
TABLESPACE "DW01",
PARTITION "SYS_P133455"
TABLESPACE "DW01",
PARTITION "SYS_P133456"
TABLESPACE "DW01",
PARTITION "SYS_P133457"
TABLESPACE "DW01")
PARALLEL 64 ;
DMA_USER.D_FINANC_RPT
-- Create table
create table D_FINANC_RPT
(
ACCT_CODE CHAR(10),
ACCT_NAME VARCHAR2(80),
JS_FLAG CHAR(1),
RPT_CODE CHAR(15),
RPT_NAME VARCHAR2(60)
)
tablespace DW01
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 80K
minextents 1
maxextents unlimited
);
-- Grant/Revoke object privileges
grant select, insert, update, delete, references, alter, index on D_FINANC_RPT to ODS_USER;
有问题SQL
select *
from dm_user.DM_FINANC a, dma_user.d_financ_rpt c
where a.acct_code = c.acct_code
and c.rpt_code = 'rpt_oe'
and to_char(a.statistics, 'yyyy-mm-dd') = '2010-01-01'
SELECT STATEMENT, GOAL = ALL_ROWS 2238 622052 62205200
PX COORDINATOR
PX SEND QC (RANDOM) SYS :TQ10001 2238 622052 62205200
HASH JOIN 2238 622052 62205200
PX RECEIVE 2 64 2560
PX SEND PARTITION (KEY) SYS :TQ10000 2 64 2560
PX BLOCK ITERATOR 2 64 2560
TABLE ACCESS FULL DMA_USER D_FINANC_RPT 2 64 2560
PX PARTITION HASH SUBQUERY 2233 4956975 297418500
TABLE ACCESS FULL DM_USER DM_FINANC 2233 4956975 297418500
Tue Mar 2 16:40:37 2010
Errors in file /u01/app/oracle/admin/dw/bdump/dw2_p642_24328.trc:
ORA-07445: 出现异常错误: 核心转储 [kxfrSmGetGroupByPnum()+32] [SIGFPE] [HP Conditional trap] [0x4000000001CAAED3] [] []
无问题
select *
from dm_user.DM_FINANC a, dma_user.d_financ_rpt c
where a.acct_code = c.acct_code
and trim(c.rpt_code) = 'rpt_oe'
and to_char(a.statistics, 'yyyy-mm-dd') = '2010-01-01'
SELECT STATEMENT, GOAL = ALL_ROWS 219 55499 5549900
PX COORDINATOR
PX SEND QC (RANDOM) SYS :TQ10001 219 55499 5549900
NESTED LOOPS 219 55499 5549900
BUFFER SORT
PX RECEIVE
PX SEND BROADCAST SYS :TQ10000
PX BLOCK ITERATOR 2 6 240
TABLE ACCESS FULL DMA_USER D_FINANC_RPT 2 6 240
PX BLOCK ITERATOR 2083 9720 583200
TABLE ACCESS FULL DM_USER DM_FINANC 2083 9720 583200
即使把表重建错误也是一样 等高手了
[本帖最后由 520268965 于 2010-7-5 09:50 编辑]