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).
Received on Fri Jun 20 2003 - 14:51:13 CDT
