EXPORT/IMPORT and archiving data

Here's my situation that I hope someone can help me with:

I've set up an archival schema which mirrors the production schema. Also I've created some stored procedures that will take older data from the production schema and move it to the archival schema. based on the age of the production data.

With the volume of data already in production, these routines would have to run for a very long time to "catch up". Since we are a 24 by 7 shop I need some way to move the data in a bulk fashion from the production schema to the archive schema without wiping out the data already in the archival schema.

Would the EXPORT/IMPORT utilities work for this? If so, what parameters do you suggest that I use which will ensure that the existing archival data doesn't get wiped out?

Is there another way to accomplish this? If so, how?

Thanks in advance! Received on Mon Dec 17 2001 - 15:36:13 CST