Re: archiving table-data

bacher wrote:
>
> hello,
>
> I have a very large table (>2GB) containing measurement-data, now I want
> to archive all rows, which are older than n hours, to tape. anyone knows
> if there are some standard products existing for archiving data, or what
> is the best way to do that?
>
> thanks,
>
> --heiko--

If the table has a timestamp ( date ) field which is updated when the record is created ( set to default to SYSDATE ), then you can achieve this by:
1. select on the timestamp, format results ( thru' sqlplus )

   to either comma or space delimited format and spool the    results into a flat file. This file can be used later    by sqlldr to bring in data.
2. Copy above records into a temp table and export it.

Shashi Received on Thu Apr 10 1997 - 00:00:00 CDT