Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g2RBUWE23188 for ; Wed, 27 Mar 2002 06:30:32 -0500 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id DAA60092; Wed, 27 Mar 2002 03:35:40 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 00434921; Wed, 27 Mar 2002 03:15:05 -0800 Message-ID: Date: Wed, 27 Mar 2002 03:15:05 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Hallas John Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Hallas John Subject: RE: Archiving Data Strategies. Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C1D580.B633E8F0" ------_=_NextPart_001_01C1D580.B633E8F0 Content-Type: text/plain; charset="iso-8859-1" As you say Ian partitioning is a obvious answer as I imagine the billing data will be quite easy to range partition using dates. However why go to 9i, 8i has many partitioning options and it may be an easier upgrade as well as a leap that management might find easier to agree to. Unfortunately removing data when there is a lot of RI involved can be quite complex and needs good knowledge of the schema and data dependencies. This knowledge is not always available and sometimes the cost in terms of man-hours is not one that management is prepared to pay. HTH John -----Original Message----- Sent: 27 March 2002 09:53 To: Multiple recipients of list ORACLE-L Hi All, I previously posted this question to the Lazydba List and got a couple of replies, but thought I would also send it to this list as well to see if I can just get a couple more (so excuses to those people that have already seen it) I am currently discussing with a customer their requirements for archiving data as their system is 4 years old and billing data is piling up which obviously is affecting performance. I am pushing for an Oracle upgrade, they are currently on 7.3.4 and I am trying to get them to go to 9i. The main reason for this is so they can use partitioning. My question to the List is to try and find out other people's experiences in archiving complex and integral data and whether most have gone the partitioning path or some other path (ie. Something like separate tables and data migration). So I would appreciate anyones comments, the path they chose, database size etc. With Thanks Ian Biddell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Biddell, Ian INET: Ian.Biddell@COMPAQ.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@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). ========================================================= This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. ========================================================= ------_=_NextPart_001_01C1D580.B633E8F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Archiving Data Strategies.

As you say Ian partitioning is a obvious answer as I imag= ine the billing data will be quite easy to range partition using dates.

However why go to 9i, 8i has many partitioning options an= d it may be an easier upgrade as well as a leap that management might find = easier to agree to.

Unfortunately removing data when there is a lot of RI inv= olved can be quite complex and needs good knowledge of the schema and data = dependencies. This knowledge is not always available and sometimes the cost= in terms of man-hours is not one that management is prepared to pay.

HTH

John



-----Original Message-----
From: Biddell, Ian [mailto:Ian.Biddell@COMPAQ.com]
Sent: 27 March 2002 09:53
To: Multiple recipients of list ORACLE-L
Subject: Archiving Data Strategies.


Hi All,

I previously posted this question to the Lazydba List and= got a couple
of replies, but thought I would also send it to this lis= t as well to see
if I can just get a couple more (so excuses to those peo= ple that have
already seen it)

I am currently discussing with a customer their requireme= nts for
archiving data as their system is 4 years old and billin= g data is piling
up which obviously is affecting performance. I am pushin= g for an Oracle
upgrade, they are currently on 7.3.4 and I am trying to = get them to go
to 9i. The main reason for this is so they can use parti= tioning.

My question to the List is to try and find out other peop= le's
experiences in archiving complex and integral data and w= hether most have
gone the partitioning path or some other path (ie. Somet= hing like
separate tables and data migration).

So I would appreciate anyones comments, the path they cho= se, database
size etc.

With Thanks
Ian Biddell
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Biddell, Ian
  INET: Ian.Biddell@COMPAQ.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-Mai= l message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGu= ru') and in
the message BODY, include a line containing: UNSUB ORACL= E-L
(or the name of mailing list you want to be removed from= ).  You may
also send the HELP command for other information (like s= ubscribing).



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D
This electronic message contains information from the mmO2 plc Group
which may be privileged or confidential. The information is intended to be =
for the use of the individual(s) or entity named above. If you are not the =
intended recipient be aware that any disclosure, copying, distribution or <= BR> use of the contents of this information is prohibited. If you have received=
this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D
 ------_=_NextPart_001_01C1D580.B633E8F0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hallas John INET: John.Hallas@o2.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@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).