roobaron,

Getting back to it. Basically the Origional tables is from another system, and the snapshot are refreased via a DBLINK. After the the snapshots are refreashed the clients wants us to maintain exports of the SNAPSHOT data for historical purposes, therefore we then export the snapshots from our systemTherefore, after the snapshot refrash process completes the export process starts, and then we have the rollback issue. I'm going to have to set up a script to capture the rollback activity during the export.

I mean nobody is quering the data at the time, and the Refreash has completed, I can't understand why the export would be using a rollback segment for read consistency if the data in the SNAP$ table is consistent.

Hmmm, anyway.

Cheers,


[Edited by grjohnson on 11-07-2001 at 11:59 PM]