From Jacques.Kilchoer@quest.com Thu, 30 Aug 2001 15:27:25 -0700 From: Jacques Kilchoer Date: Thu, 30 Aug 2001 15:27:25 -0700 Subject: RE: Archiving data Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: 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@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 where id < xxxx; > > What is the best way of doing this.