Inserting in partition, only going to maxvalue????

From: jagadba <jgabe_at_suncom.com>
Date: 22 Mar 2006 08:34:58 -0800
Message-ID: <1143045298.505441.168110@i40g2000cwc.googlegroups.com>

I have a table:

CREATE TABLE MESSAGE_LOG_DW
(

  SENT_MESSAGE        VARCHAR2(4000 BYTE),
  RCVD_DATE           DATE,
  SENT_DATE           DATE,
  SEQ_ID              NUMBER(20),
  TRANSACTION_TYPE    VARCHAR2(20 BYTE),
  RCVD_MESSAGE        VARCHAR2(4000 BYTE),
  SENT_MESSAGE2       VARCHAR2(4000 BYTE),
  STATUS              CHAR(1 BYTE),
  LOGIN               VARCHAR2(50 BYTE),
  AGENT_REQUEST       VARCHAR2(4000 BYTE),
  AGENT_RESPONSE      VARCHAR2(4000 BYTE),
  REQUEST_DATE        DATE,
  RESPONSE_DATE       DATE,
  ATLYS_ACCOUNT       VARCHAR2(20 BYTE),
  APPLICATION_NUMBER  VARCHAR2(12 BYTE),
  RCVD_MESSAGE2       VARCHAR2(4000 BYTE)

)
TABLESPACE BOB_DATA
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
PARTITION BY RANGE (REQUEST_DATE)
(
  PARTITION W08 VALUES LESS THAN (TO_DATE(' 0006-02-27 00:00:00',
'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    LOGGING
    NOCOMPRESS
    TABLESPACE W08_DW
    PCTFREE 10
    INITRANS 1
    MAXTRANS 255
    STORAGE (

                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                BUFFER_POOL      DEFAULT
               ),

  PARTITION W09 VALUES LESS THAN (TO_DATE(' 0006-03-06 00:00:00',
'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    LOGGING
    NOCOMPRESS
    TABLESPACE W09_DW
    PCTFREE 10
    INITRANS 1
    MAXTRANS 255
    STORAGE (

                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                BUFFER_POOL      DEFAULT
               ),

  PARTITION W10 VALUES LESS THAN (TO_DATE(' 0006-03-13 00:00:00',
'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    LOGGING
    NOCOMPRESS
    TABLESPACE W10_DW
    PCTFREE 10
    INITRANS 1
    MAXTRANS 255
    STORAGE (

                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                BUFFER_POOL      DEFAULT
               ),

  PARTITION W11 VALUES LESS THAN (MAXVALUE)     LOGGING
    NOCOMPRESS
    TABLESPACE W11_DW
    PCTFREE 10
    INITRANS 1
    MAXTRANS 255
    STORAGE (

                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                BUFFER_POOL      DEFAULT
               )

)
NOCACHE
NOPARALLEL;

##################################################################

When inserting data with:

insert into message_log_test select * from prod.message_log where request_date >= to_date('01/01/2006','mm/dd/yyyy');

All data only goes into the PARTITION W11 VALUES LESS THAN (MAXVALUE). I thought it would go into the other partitions.

--jaga Received on Wed Mar 22 2006 - 10:34:58 CST