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 SolarisScenario: We
have a table where we store the consolidated weekly numbers onthe number of
disconnects, reconnects, transfers etc. Our business week isfrom 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 weeksfor 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 yearand week number should go to a specific partition.
Searched Metalink andOracle docs but didn't get an answer.Is there a
way to accomplish this without adding a date column to
thistable?TIAPrakash-- Please see the official
ORACLE-L FAQ:
http://www.orafaq.com--
Author: Bala, Prakash INET: prakash.bala_at_cingular.comFat
City Network Services -- (858) 538-5051 FAX: (858)
538-5051San Diego, California --
Public Internet access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Fri Jul 06 2001 - 10:55:21 CDT
