Rekan indo-Oracle
Mohon bantuannya,. saat ini sy memiliki table yg telah di partisi,.. ad pun
table yg sy buat dan kolom yg sy partisi ad di bawah ini :
/*-----------------------CREATE TABLE WELL_DPROD2 (WELL_DPROD_S NUMBER NOT
NULL,WELL_NAME VARCHAR2(40),WELL_CONTRACTOR VARCHAR2(6),STRUCTURE_FORMATION_S
NUMBER,WELL_DPROD_DATE DATE NOT NULL,WELL_DPROD_GROSS NUMBER,WELL_DPROD_WC
NUMBER,WELL_DPROD_INJECTION_GAS NUMBER,WELL_DPROD_TOTAL_GAS
NUMBER,WELL_DPROD_CREATED_DATE DATE,WELL_DPROD_CREATED_BY
VARCHAR2(10),WELL_DPROD_QC_DATE DATE,WELL_DPROD_QC_BY
VARCHAR2(10),WELL_DPROD_INTERVAL VARCHAR2(100),WELL_DPROD_WATER_INJECTION
NUMBER,WELL_DPROD_UNIT VARCHAR2(10),
CONSTRAINT "CONST_WD2" UNIQUE("WELL_NAME","WELL_DPROD_DATE")USING
INDEX TABLESPACE "TEST",
CONSTRAINT "PK_WD2"PRIMARY KEY("WELL_DPROD_S")USING INDEXTABLESPACE "TEST",
CONSTRAINT "FOREIGN_WD_WELL2"FOREIGN
KEY("WELL_NAME","WELL_CONTRACTOR")REFERENCES
"UJANK"."WELL"("WELL_NAME","WELL_CONTRACTOR"),
CONSTRAINT "FOREIGN_WD_S_F2"FOREIGN KEY("STRUCTURE_FORMATION_S")REFERENCES
"UJANK"."STRUCTURE_FORMATION"("STRUCTURE_FORMATION_S")
)TABLESPACE "TEST" PARTITION BY RANGE(WELL_DPROD_DATE)(PARTITION PROD_JAN_2009
VALUES LESS THAN(TO_DATE('01-02-2009','DD-MM-YYYY')) TABLESPACE TEST,PARTITION
PROD_FEB_2009 VALUES LESS THAN(TO_DATE('01-03-2009','DD-MM-YYYY')) TABLESPACE
TEST,PARTITION PROD_MAR_2009 VALUES LESS
THAN(TO_DATE('01-04-2009','DD-MM-YYYY')) TABLESPACE TEST,PARTITION
PROD_APR_2009 VALUES LESS THAN(TO_DATE('01-05-2009','DD-MM-YYYY')) TABLESPACE
TEST,PARTITION PROD_MAY_2009 VALUES LESS
THAN(TO_DATE('01-06-2009','DD-MM-YYYY')) TABLESPACE TEST,PARTITION
PROD_JUN_2009 VALUES LESS THAN(TO_DATE('01-07-2009','DD-MM-YYYY')) TABLESPACE
TEST,PARTITION PROD_JUL_2009 VALUES LESS
THAN(TO_DATE('01-08-2009','DD-MM-YYYY')) TABLESPACE TEST,PARTITION
PROD_AUG_2009 VALUES LESS THAN(TO_DATE('01-09-2009','DD-MM-YYYY')) TABLESPACE
TEST,PARTITION PROD_SEP_2009 VALUES LESS
THAN(TO_DATE('01-10-2009','DD-MM-YYYY')) TABLESPACE TEST,PARTITION
PROD_OCT_2009 VALUES LESS
THAN(TO_DATE('01-11-2009','DD-MM-YYYY')) TABLESPACE TEST,PARTITION
PROD_NOV_2009 VALUES LESS THAN(TO_DATE('01-12-2009','DD-MM-YYYY')) TABLESPACE
TEST,PARTITION PROD_DEC_2009 VALUES LESS
THAN(TO_DATE('01-01-2010','DD-MM-YYYY')) TABLESPACE TEST)ENABLE ROW
MOVEMENT;--------------------------*/
sy sdh mencoba melakukan perintah select untuk table WELL_DPROD2(dgn memanggil
nama partisi yg sy inginkan)CONTOHNYA :.....FROM WELL_DPROD2
PARTITION(PROD_DEC_2009) ... yg sy relasikan dgn beberapa table dan hasilnya
sngt cepat dan pertanyaannya adalah:
- bisakah table yg terpartisi tersebut sy query(select) kan dengan menggunakan
between, yg sy maksud,... sy ingin menampilkan data dari table WELL_DPROD2 yg
partisinya dari bulan May-2009 hingga DEC-2009(me-nyelect data dr table
WELL_DPROD2 dgn menyebutkan nama dr partisi2 table tersebut),..sy pernah
mencoba jika nama pd partisi tersebut tidak disebutkan, mmng bisa,.. akan
tetapi, jika sy lihat hasil kecepatan prosesnya, sama seperti table yg tidak di
partisi.
mohon bantuan dan solusinyamohon maaf jika penjelasannya terlalu
rumit,..sebelum dan sesudahnya sy ucapkan terima kasih bnyk untuk rekan2
indo-oracle,
boby
[Non-text portions of this message have been removed]
