SNAPSHOT TOO OLD ON THE EXPORT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SNAPSHOT TOO OLD ON THE EXPORT

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    if I run an export and I got the snapshot too old from the rollback, what do I need to do to fix this problem ???

    thanks

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    1. Run your export when your database is not so bussy, i.e. when there is low ammount of changes to the database by other sessions.

    or

    2. If you are using CONSISTENT=Y option in your export, reconsider again if you realy need tables to be exported in consistent mode in relation to each other. With CONSISTENT=N you have much less cance to get ORA-1555

    or

    3. Make your rollback segments bigger and/or make more of them available
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width