This is how we purge large, heavily (almost always in use) accessed tables.
We build have an archive (permanent) table that looks just like the
original table. We usually use a pro*c program or pl/sql to populate this
table. We then dump the archive table to an OS file. Once we have the
data archived we then use the archive table as the driver to delete the
rows from the parent table. We truncate the archive table just prior to
reuse.
Vinnie <browns1_at_borg.com> wrote in article <35D99262.E084963_at_borg.com>...
> I am running ORACLE 7.3 on Soloris. I have one table which generates
> enormous amounts of records( 700K in a few days). I am trying to figure
> out a way to export the data then delete the same data!. I am using
> export & TRUNCATE. How can I make sure that no new records are inserted
> while I am doing this? Basically I want to export the same data I
> delete & not loose any new records in between!
>
> HELP!
>
> Vinnie Salerno
> Litton/PRC
>
>
Received on Wed Aug 19 1998 - 08:53:24 CDT
