Hi,
I have IOT (index organization Table) partitioned by day, please help me for tuning sqlldr Vs index primary key to avoid back log ( to quick insert)

Average data loaded per day is 150 Millions

Desc my_table
CREATE TABLE DBM_MSC_CDR
(
  SUBNO             VARCHAR2(20 BYTE),
  B_SUBNO           VARCHAR2(20 BYTE),
  CALL_DURATION     NUMBER(5),
  CALL_TYPE         VARCHAR2(3 BYTE),
  TRANSDATE         DATE,
  FILE_ID           NUMBER(9),
  UPDDATE           DATE                        DEFAULT trunc(sysdate),
  CONSTRAINT DBM_MSC_CDR_PK PRIMARY KEY (SUBNO, B_SUBNO, TRANSDATE, CALL_TYPE, CALL_DURATION)
)
ORGANIZATION INDEX
  PARTITION BY RANGE (TRANSDATE)

Best regards
 


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page