Hey Dennis: 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.. Thanks very much for your help. Ishwar -----Original Message----- DENNIS WILLIAMS Sent: Friday, June 20, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Ishwar - What Oracle version. Just off the top of my head, I think that 8i only allows the subpartition to be hashed. What is your goal? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Friday, June 20, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Hey, Can anyone say if there is a way to breakup an existing partition into subpartitons. The partition contains data. Thx Ishwar. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ishwar Tewari 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ishwar Tewari 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).