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

"jagadba" <jgabe_at_suncom.com> a écrit dans le message de news: 1143045298.505441.168110_at_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
|

All your partition but the last one are for year 0006 (not 2006) so all 2006 data go to the last partition.

Regards
Michel Cadot Received on Wed Mar 22 2006 - 10:52:11 CST