Partitioning in 8i

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Fri, 10 Nov 2000 08:34:48 -0800 (PST)
Message-Id: <10676.121734@fatcity.com>

--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 &gt; 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?<BR><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br> <a href="http://shopping.yahoo.com/">Yahoo! Shopping</a> - Thousands of Stores. Millions of Products. All with one Wallet.
--0-434248626-973874088=:12870--
Received on Fri Nov 10 2000 - 10:34:48 CST