Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    exp_current_library is not exporting complete tables

    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    I'm working on extracting production data to our new test server, using exp_current_library.
    At least 3 times now, I have had incomplete tables result from this process.

    For example, on Monday I exported ABC50. Only about 1.7 million of over 2 million Z30 records were exported. Only about 2 million of over 6 million Z30H records were exported. I think that Z34, Z35, and Z71 were also short. Today with ABC01, only about 2 million of 16 million Z01 records were exported.

    In all cases, I have seen no errors in the output log. When I export the tables individually using p_file_03 with the same parameters, it worked fine. Could there be something wrong with p_file_03? Or something wrong with exp_current_library?

    Resolution:
    You need to increase the rollback segments and run the export when there is little database activity.
    Note: Oracle 9 doesn't have rollback segments, it has the undo tablespace. This was fixed by increasing the undo_retention time:
    SQL> ALTER SYSTEM SET UNDO_RETENTION=36000;


    • Article last edited: 10/8/2013