Message-Id: <10676.121734@fatcity.com> From: Chuck Hamilton Date: Fri, 10 Nov 2000 08:34:48 -0800 (PST) Subject: Partitioning in 8i --0-434248626-973874088=:12870 Content-Type: text/plain; charset=us-ascii Can someone help with this problem. I have an order table with > 100 million orders. I want to partition it based on the month the order was taken and every month add a new partition and drop the one that's 25 months old. When I do this however it invalidates the PK index which is simply the order's number (a sequential number). I can't locally partition the PK index because it doesn't contain the partition key column (order date). I can't change the PK because that would allow duplicate order numbers if created on different days. What can I do to quickly drop the 25th month without invalidating the PK index which effectively disables the entire table? --------------------------------- Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. All with one Wallet. --0-434248626-973874088=:12870 Content-Type: text/html; charset=us-ascii Can someone help with this problem. I have an order table with > 100 million orders. I want to partition it based on the month the order was taken and every month add a new partition and drop the one that's 25 months old. When I do this however it invalidates the PK index which is simply the order's number (a sequential number). I can't locally partition the PK index because it doesn't contain the partition key column (order date). I can't change the PK because that would allow duplicate order numbers if created on different days. What can I do to quickly drop the 25th month without invalidating the PK index which effectively disables the entire table?


Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. All with one Wallet. --0-434248626-973874088=:12870--