Message-ID: <BLU108-W11D750F8257780265E814897640@phx.gbl>
Content-Type: multipart/alternative; boundary="_1467542c-f078-4db1-a8e6-2e68f70f7cf3_"
From: Joe Smith <joe_dba@hotmail.com>
To: <oracle-l@freelists.org>
Subject: partitioned tables
Date: Tue, 11 Dec 2007 15:51:06 -0600
MIME-Version: 1.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: joe_dba@hotmail.com
--_1467542c-f078-4db1-a8e6-2e68f70f7cf3_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


My primary key is a composite of 3 columns, but I range parition only on on=
e column.=20
 It that a problem?  I know it is a date field, but we are using a number f=
or a date, i.e. yyyymmdd.  Would I need to set up a partitioned tablespace =
for the index, i.e. PK?=20
CREATE TABLE F_MBR_ACCT_TRANSACTION(MBR_ACCT_ID               INTEGER  NOT =
NULL ,TXN_DATE_ID               INTEGER  NOT NULL ,SPONSOR_TRAN_ID       IN=
TEGER  NOT NULL ,TXN_DTTM                  DATE  NULL ,TXN_AMOUNT          =
   NUMBER(14,2)  NULL CONSTRAINT  F_MBR_ACCT_TRANSACTION_PK PRIMARY KEY (MB=
R_ACCT_ID,TXN_DATE_ID,SPONSOR_TRAN_ID))partion by range (TXN_DATE_ID)(parti=
tion jan_2007 values less than (20070131) tablespace smart_part_jan_2007, p=
artition feb_2007 values less than (20070228) tablespace smart_part_feb_200=
7, . . . partition jan_2007 values less than (20071231) tablespace smart_pa=
rt_dec_2007);
=20
=20
_________________________________________________________________
Share life as it happens with the new Windows Live.
http://www.windowslive.com/share.html?ocid=3DTXT_TAGHM_Wave2_sharelife_1220=
07=

--_1467542c-f078-4db1-a8e6-2e68f70f7cf3_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class=3D'hmmessage'>
My primary key is a composite of 3 columns, but I range parition only on on=
e column.<BR>&nbsp;<BR>
&nbsp;It that a problem?<BR>&nbsp;<BR><BR>&nbsp;I know it is a date field, =
but we are using a number for a date, i.e. yyyymmdd.<BR>&nbsp;<BR>&nbsp;Wou=
ld I need to set up a partitioned tablespace for the index, i.e. PK?<BR>&nb=
sp;<BR>
CREATE TABLE F_MBR_ACCT_TRANSACTION<BR>(<BR>MBR_ACCT_ID&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INTEGER&nb=
sp; NOT NULL ,<BR>TXN_DATE_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INTEGER&nbsp; NOT NULL ,<BR>SPONSOR_=
TRAN_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INTEGER&nbsp; NOT NULL ,<BR>TXN=
_DTTM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DATE&nbsp; NULL ,<BR>TXN_AMOUNT&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUMBER(14,2)&=
nbsp; NULL <BR>CONSTRAINT&nbsp; F_MBR_ACCT_TRANSACTION_PK PRIMARY KEY (MBR_=
ACCT_ID,TXN_DATE_ID,SPONSOR_TRAN_ID))<BR>partion by range (TXN_DATE_ID)<BR>=
(partition jan_2007 values less than (20070131) tablespace smart_part_jan_2=
007,<BR>&nbsp;partition feb_2007 values less than (20070228) tablespace sma=
rt_part_feb_2007,<BR>&nbsp;.<BR>&nbsp;.<BR>&nbsp;.<BR>&nbsp;partition jan_2=
007 values less than (20071231) tablespace smart_part_dec_2007);<BR>
&nbsp;<BR>
&nbsp;<BR><br /><hr />Share life as it happens with the new Windows Live. <=
a href=3D'http://www.windowslive.com/share.html?ocid=3DTXT_TAGHM_Wave2_shar=
elife_122007' target=3D'_new'>Share now!</a></body>
</html>=

--_1467542c-f078-4db1-a8e6-2e68f70f7cf3_--
--
http://www.freelists.org/webpage/oracle-l