| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Range partition
Joe,
My thought exactly. Normally we think of partitioning in a linear fashion, namely one table broken up into pieces that should stack one on top of the other. But two dimension partitioning is possible using the multi-key method. Only problem that I'm aware of, through 8.1.6 is that you cannot have a default partition.
Dick Goulet
____________________Reply Separator____________________ Author: "JOE TESTA" <JTESTA_at_longaberger.com> Date: 7/6/2001 8:20 AM
a multi-key partition will not work for you or am i missing something in the question?
joe, living on the bleeding edge trying to get stupid management server of OEM to work for 9i :)
>>> prakash.bala_at_cingular.com 07/06/01 10:26AM >>> Hello,
Oracle 8.1.7 on Sun Solaris
Scenario: We have a table where we store the consolidated weekly numbers on the number of disconnects, reconnects, transfers etc. Our business week is from Wednesday to Tuesday and so each week has a number assigned to it. Also, the week doesn't span across months. So we have a total of 63 weeks for 2001. The table stucture is as follows:
activity_year number(4), week_num number(2), company_code varchar2(10), channel_code varchar2(20), spectrum_code varchar2(4), subscriber_code varchar2(6), bop number(10), initial_add number(10), volun_disc number(10), involun_disc number(10).....
I need to partition this table in such a way that the data for a given year and week number should go to a specific partition. Searched Metalink and Oracle docs but didn't get an answer.
Is there a way to accomplish this without adding a date column to this table?
TIA Prakash
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash INET: prakash.bala_at_cingular.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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 Jul 06 2001 - 12:53:37 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4522.1800" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 6pt MS Sans Serif; MARGIN-LEFT: 2px">
<DIV><FONT size=1>a multi-key partition will not work for you or am i missing
something in the question?</FONT></DIV>
<DIV><FONT size=1></FONT> </DIV>
<DIV><FONT size=1>joe, living on the bleeding edge trying to get stupid
management server of OEM to work for 9i :)</FONT></DIV>
<DIV><BR><BR>>>> prakash.bala_at_cingular.com 07/06/01 10:26AM
>>><BR>Hello,<BR><BR>Oracle 8.1.7 on Sun Solaris<BR><BR>Scenario: We have a table where we store the consolidated weekly numbers on<BR>the number of disconnects, reconnects, transfers etc. Our business week is<BR>from Wednesday to Tuesday and so each week has a number assigned to it.<BR>Also, the week doesn't span across months. So we have a total of 63 weeks<BR>for 2001. The table stucture is as follows:<BR><BR>activity_year &nb sp; number(4),<BR>week_num &nbs p; number(2),<BR>company_code varchar2(10),<BR>channel_code &nb sp; varchar2(20),<BR>spectrum_code &n bsp; varchar2(4),<BR>subscriber_code & nbsp; varchar2(6),<BR>bop & nbsp; &nb sp; number(10),<BR>initial_add number(10),<BR>volun_disc & nbsp; number(10),<BR>involun_disc   ; number(10).....<BR><BR>I need to partition this table in such a way that the data for a given year<BR>and week number should go to a specific partition. Searched Metalink and<BR>Oracle docs but didn't get an answer.<BR><BR>Is there a way to accomplish this without adding a date column to this<BR>table?<BR><BR>TIA<BR><BR>Prakash<BR>-- <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.com<BR>--
<BR>Author: Bala, Prakash<BR> INET: prakash.bala_at_cingular.com<BR><BR>Fat
City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR >To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).<BR></DIV></BODY></HTML> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).
 |
 |