When you say 9i, do you mean 9.0.1 or 9.2.0? In 9.2.0 You can have list subpartitions. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_73a.htm#2153058
> -----Original Message----- > From: Ishwar Tewari [mailto:[EMAIL PROTECTED] > > I created a range partition table with the last high_value > being maxvalue. > The partition key is partner_id (an incremental sequence). > Now pmax (the last partition) has become very big and gives > "snapshot too > old.." while exporting. > > Ultimate Plan > ============= > I realize that the ultimate solution will be the split the > partition pmax, > into enough segments so that > the new pmax has no data. Then at this point I will drop the > pmax partition. > Therefore when new partners come I will add > partitions accordingly. > > Maybe > ===== > But I was thinking If I can make pmax into a hashed > subpartition, it will > also distribute the data reasonably. > I dont have to have the segments separated by the partner_id > because the > data are not evenly distributed to the partners. > partner_id , count(*) > 1 4646545542 > 2 11164546466 > ... and so on.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
