I altered a table through Toad which set up range partitioning on a table.
I had to make another alteration to the table and the table was showing as not partitioned.
This is the generated DDL for the table:
CREATE TABLE FACT_PERSON_ELG_MM (
PERSON_ELIG_MM_KEY INTEGER NOT NULL,
PART_NBR INTEGER NOT NULL,
YEAR_MTH_ID CHARACTER(6),
PERSON_KEY INTEGER,
ELIG_DEMO_PRF_ID INTEGER,
CNTY_CD CHARACTER(2),
EOM_ELIG_IND CHARACTER(1),
BKDATED_ELIG_IND CHARACTER(1),
ELIG_IND CHARACTER(1),
MCAID_PGM_ID CHARACTER(4),
CREATED_YR_MTH_ID CHARACTER(6),
SPNDWN_IND CHARACTER(1),
RESIDENCE_CNTY_CD CHARACTER(2),
CITY_CD INTEGER,
ZIP_CD CHARACTER(5),
PERSON_CNT_AMT SMALLINT DEFAULT 1,
EXT_MCAID_CD CHARACTER(1) NOT NULL DEFAULT
)
PARTITION BY RANGE ( PART_NBR NULLS LAST ) (
PARTITION 1 STARTING 1 INCLUSIVE ENDING 1 INCLUSIVE IN WFDWH1TS_200201,
....
PARTITION 72 STARTING 72 INCLUSIVE ENDING 72 INCLUSIVE IN WFDWH1TS_200712 );
In the Alter Table Window, the table is shows PARTITIONED false and it should be true.
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center