| when partitioning the table should the partitioning must also happen to indexes assiociated with tab [message #344788] |
Mon, 01 September 2008 04:53  |
|
|
Hi All,
i wanted to perform range partitioning on table which contains indexs on it.Please find the table syntax below.If i want to perform range(weekly) partition with Time1 as the partition key should i also partition the index i.e Quotation_ID .Please help.
CREATE TABLE history( Time1 DATE NOT NULL, Total NUMBER(10,2), SQLString clob, tObjectID VARCHAR2(35), Views VARCHAR2(50), Quotation_ID NUMBER (10), ND
A_ID NUMBER (10), AGI_ID NUMBER (10), RIC VARCHAR2(50) DEFAULT NULL, Asset_type VARCHAR2(30), Tag NUMBER (10), Database_ID Number(5))
);
ALTER TABLE history ADD CHECK(Quotation_ID BETWEEN -2147483648 AND 2147483647);
ALTER TABLE history ADD CHECK(NDA_ID BETWEEN -2147483648 AND 2147483647);
ALTER TABLE history ADD CHECK(AGI_ID BETWEEN -2147483648 AND 2147483647);
ALTER TABLE history ADD CHECK(Tag BETWEEN -2147483648 AND 2147483647);
ALTER TABLE history ADD CHECK(Database_ID BETWEEN -32767 AND 32768);
CREATE INDEX p_index ON history (quotation_id);
Exit;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
