RE: Archiving data

[Ravindra Basavaraja]

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.

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques Kilchoer
Sent: Thursday, August 30, 2001 4:44 PM
To: Multiple recipients of list ORACLE-L
Subject: 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 [mailto:[EMAIL PROTECTED]]
>
> 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
> 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
> 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.