When faced with a similar situation requiring archiving of records (with
rows in a dozen tables) as they expired, I wrote an oraperl program to write
the data to a set of flat files with fixed length records, deleting the rows
from the database as it ran. Restoration is just a matter of running the
flat file through a filter to select records, and loading via SQL*Loader,
or by another oraperl program.
Without oraperl, I'd be up to my eyebrows in Pro*C by now...YECH!
Cheers!
--
"Well, it's rather brutal here. We're | dave_at_msb.com (Dave Lockwood)
advising all our clients to put every- | UUCP: ...!uupsi!mpoint!dave
thing they've got into canned food and | Sysop of Meetpoint Station BBS
shotguns." - Brain Gremlin (Gremlins II) | cat flames | mail santa_at_north.pole