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: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
> 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.
Received on Thu Aug 30 2001 - 17:27:25 CDT