Partition Table [message #340505] |
Wed, 13 August 2008 02:34  |
vipinsonkar2000
Messages: 38 Registered: May 2008
|
Member |
|
|
Hi
I have a partion table :
CREATE TABLE PAS_SIG_SCRIPT
(
FILL_DT DATE NOT NULL,
SIG_SCRIPT_SEQ_NBR NUMBER(12) NOT NULL,
STORE_NBR NUMBER(5) NOT NULL,
RX_NBR NUMBER(7) NOT NULL,
SIG_SEQ_NBR NUMBER(9) NOT NULL,
INSERT_DT_TME DATE NOT NULL,
CUR_IND VARCHAR2(1 BYTE) NOT NULL
)
PARTITION BY RANGE (FILL_DT)
(
PARTITION PQ20041 VALUES LESS THAN
(TO_DATE(' 2004-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PARTITION PQ20042 VALUES LESS THAN
(TO_DATE(' 2004-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PARTITION PQ20043 VALUES LESS THAN
(TO_DATE(' 2004-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
LOGGING
....and so on
Now my requirment is to write a query which take a particular date and tell me whether partition is exist or not.I know that it can be done with all_tab_partitions table bupLease write exact code.
Thanks and regards.
[Updated on: Wed, 13 August 2008 02:43] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|