Ajuda Query

[ramasineParticipante]

Fala varmbrust!!!
Segue abaixo, a tabela usa partição por hash..

CREATE TABLE DW_ECHI.TB_CMS_ECHI
(
CALLID NUMBER(12),
ACWTIME NUMBER(12),
ANSHOLDTIME NUMBER(12),
CONSULTTIME NUMBER(12),
DISPTIME NUMBER(12),
DURATION NUMBER(12),
SEGSTART DATE,
SEGSTOP DATE,
TALKTIME NUMBER(12),
NETINTIME NUMBER(12),
ORIGHOLDTIME NUMBER(12),
DISPIVECTOR NUMBER(12),
DISPSPLIT NUMBER(6),
FIRSTVECTOR NUMBER(6),
SPLIT1 NUMBER(6),
SPLIT2 NUMBER(6),
SPLIT3 NUMBER(6),
TKGRP NUMBER(6),
EQ_LOCID NUMBER(6),
ORIG_LOCID NUMBER(6),
ANS_LOCID NUMBER(6),
OBS_LOCID NUMBER(6),
ASSIST CHAR(1 BYTE),
AUDIO CHAR(1 BYTE),
CONFERENCE CHAR(1 BYTE),
DA_QUEUED CHAR(1 BYTE),
HOLDABN CHAR(1 BYTE),
MALICIOUS CHAR(1 BYTE),
OBSERVINGCALL CHAR(1 BYTE),
TRANSFERRED CHAR(1 BYTE),
AGT_RELEASED CHAR(1 BYTE),
ACD NUMBER(6),
DISPOSITION NUMBER(6),
DISPPRIORITY NUMBER(6),
HELD NUMBER(6),
SEGMENT NUMBER(6),
ANSREASON NUMBER(6),
ORIGREASON NUMBER(6),
DISPSKLEVEL NUMBER(6),
EVENT1 NUMBER(6),
EVENT2 NUMBER(6),
EVENT3 NUMBER(6),
EVENT4 NUMBER(6),
EVENT5 NUMBER(6),
EVENT6 NUMBER(6),
EVENT7 NUMBER(6),
EVENT8 NUMBER(6),
EVENT9 NUMBER(6),
UICD VARCHAR2(21 BYTE),
DISPVDN VARCHAR2(8 BYTE),
EQLOC VARCHAR2(10 BYTE),
FIRSTVDN VARCHAR2(8 BYTE),
ORIGLOGIN VARCHAR2(10 BYTE),
ANSLOGIN VARCHAR2(10 BYTE),
LASTOBSERVER VARCHAR2(10 BYTE),
DIALED_NUM VARCHAR2(25 BYTE),
CALLING_PTY VARCHAR2(13 BYTE),
LASTDIGITS VARCHAR2(17 BYTE),
LASTCWC VARCHAR2(17 BYTE),
CALLING_II VARCHAR2(3 BYTE),
CWC1 VARCHAR2(17 BYTE),
CWC2 VARCHAR2(17 BYTE),
CWC3 VARCHAR2(17 BYTE),
CWC4 VARCHAR2(17 BYTE),
CWC5 VARCHAR2(17 BYTE),
CD_PABX NUMBER(1),
VDN2 VARCHAR2(8 BYTE),
VDN3 VARCHAR2(8 BYTE),
VDN4 VARCHAR2(8 BYTE),
VDN5 VARCHAR2(8 BYTE),
VDN6 VARCHAR2(8 BYTE),
VDN7 VARCHAR2(8 BYTE),
VDN8 VARCHAR2(8 BYTE),
VDN9 VARCHAR2(8 BYTE),
QUEUETIME NUMBER(12),
RINGTIME NUMBER(12),
ASAIUUI VARCHAR2(100 BYTE),
UUI_LEN NUMBER(4),
ECHI_VERSION NUMBER(10),
ECHI_SEQUENCE NUMBER(10),
NU_PROTOCOLO NUMBER,
DT_CARGA DATE DEFAULT SYSDATE,
NU_TRANSFERENCIA NUMBER,
NM_ARQUIVO_ORIGEM VARCHAR2(100 BYTE)
)
TABLESPACE TSECHID1
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
PARTITION BY RANGE (SEGSTART)
SUBPARTITION BY HASH (DISPSPLIT)
…..