|
-
Thanks, but the other thread talks about changes being made to the tables at the same time as the export occurs, or the making use of the CONSISTENT=Y. In my case, the tables are not changing, they are READONLY access to users AFTER the snapshot refreash has occured and I'm not using the CONSISTENT paramerter in the par file. Therefore, what I'm wondering is, just becasue the REFREASH process has completeted, is there still data needed to make a consistent read of the data.
I've also exported large GB database without any problems with rollbacks, and when the rollback segments have been tiny and the RBS tablesapce being about 500 MB, so I don't believe the ROLLBACK SEGMENTS are used in every export function unless of course they are used for a consistent read.
Any more ideas peps.
Cheers,
OCP 8i, 9i DBA
Brisbane Australia
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|