Re: Partitioning in 8i

From: <danut.bancea_at_ifl.bmo.ca>
Date: Fri, 10 Nov 2000 14:07:23 -0500
Message-Id: <10676.121771@fatcity.com>

This is a multipart message in MIME format. --=_alternative 006908AD85256993_=
Content-Type: text/plain; charset="us-ascii"

Hi,

You can try this but I'm not sure that is working:

create a index which will contain the primary key column, (you can add other column also), and after that you can creat the PK . In this case the PK will use current index.

Normally if you create the index local, when you will drop the partition will drop just the index which corespond to that partition.

But again, I didn't tested, I'am just thinking that is possible to work.

Danut,

Chuck Hamilton <chuck_hamilton_at_yahoo.com> Sent by: root_at_fatcity.com
11/10/00 11:36 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Partitioning in 8i

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.

--=_alternative 006908AD85256993_=
Content-Type: text/html; charset="us-ascii"

 Hi,
 
 You can try this but I'm not sure that is working:
 
 create a index which will contain the primary key column, (you can add other column also), and after that you can creat the PK . In this case the PK will use current index.
 
 Normally if you create the index local, when you will drop the partition will drop just the index which corespond to that partition.
 
 But again, I didn't tested, I'am just thinking that is possible to work.
 
 Danut,
 
 
 
 
 
<table width=100%>
<tr valign=top>
<td>
<td>Chuck Hamilton <chuck_hamilton_at_yahoo.com>
 Sent by: root_at_fatcity.com
11/10/00 11:36 AM
 Please respond to ORACLE-L
 
<td>        
         To:        Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
         cc:        
         Subject:        Partitioning in 8i</table>
 
 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? 

 

<hr>Do You Yahoo!? 
<a href=http://shopping.yahoo.com/>Yahoo! Shopping</a> - Thousands of Stores. Millions of Products. All with one <a href=http://wallet.yahoo.com/>Wallet</a>.
Received on Fri Nov 10 2000 - 13:07:23 CST