From ravindra@sentica.com Thu, 30 Aug 2001 16:20:26 -0700
From: "Ravindra Basavaraja" <ravindra@sentica.com>
Date: Thu, 30 Aug 2001 16:20:26 -0700
Subject: RE: Archiving data
Message-ID: <F001.0037E5EA.20010830163036@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: RE: Archiving data



The 
database is running on older versions not on 8.0(i guess 7.3.4) .This is at 
one of the customers site and the solution is for that 
database.
They 
might upgrade to new version after few months but till then we got to live with 
that.
<FONT face=Arial color=#0000ff 
size=2> 
<FONT face=Arial color=#0000ff 
size=2> 

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: root@fatcity.com 
  [mailto:root@fatcity.com]On Behalf Of Jacques KilchoerSent: 
  Thursday, August 30, 2001 4:44 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Archiving data
  This sounds like a textbook case for table partitioning. Read 
  the manual on partitions. You ARE on oracle 8.0 or above, I 
imagine?
  > -----Original Message----- > 
  From: Ravindra Basavaraja [<A 
  href="mailto:ravindra@sentica.com">mailto:ravindra@sentica.com] 
  > > I have few tables that will 
  be getting populated with transaction data > 
  continuously.This table > grows to large size.For 
  us once the transaction is completed > we don't 
  need > the data to be in the database, 
  > but we cannot delete them either.We need to archive 
  those > records and clear <FONT 
  size=2>> those archived records > from the 
  table.Like out of the 3million records I want to > 
  keep this months > records and archive the 
  > remaining.There are few set of tables which needs to be 
  > archived and they > 
  are all related. > > I 
  can think of creating a new table and populating the table <FONT 
  size=2>> with records > that needs to be 
  archived and > after this those records can be 
  deleted.Ex > > create 
  table T1 as select * from <tablename> where id < xxxx; 
  > > What is the best way of 
  doing this.