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_at_fatcity.com   [mailto:root_at_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_at_sentica.com">mailto:ravindra_at_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. Received on Thu Aug 30 2001 - 18:20:26 CDT