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

    p_file_03: "Filesize limit exceeded" for z97 table

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

    After running parallel indexing (with FCL02 as the parallel library), we are trying to copy export the FCL02 z9n tables for copying to FCL01.

    When we try to export the z97 using p_file_03, we get the following error, seen in the $alephe_scratch/fcl02_p_file_03.00205:

    in_fl: /exlibris/aleph/u18_1/fcl02/files/z97.seqaa.DLM out_fl: /exlibris/aleph/u18_1/fcl02/files/z97.seqaa
    Filesize limit exceeded

    p_file_03 is not recommended as a transfer tool. It's main purpose is for internal use.

    Tables that output to a sequential file greater than 2G are limited by the file system file size, if you did not specify the split size, the sequential file is not split to portions.

    To export/import tables between different Oracle instances use the Oracle exp/imp Data Pump procedures instead:

    Export: csh -f $aleph_proc/oracle_expdp_table ABC01,z97 > & oracle_expdp_table.jz97.js.log &

    Import: csh -f $aleph_proc/oracle_impdp_table ABC01,z97 > & oracle_impdp_table.z97.js.log &

    • Article last edited: 10/8/2013