Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. p_file_03: "Filesize limit exceeded" for z97 table

    p_file_03: "Filesize limit exceeded" for z97 table

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    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

    Resolution:
    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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • p_file_02: Conversion from MARCXML to Aleph sequential missing FMT field
      • p_file_03: "Invalid or missing Oracle table name" for bib file
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved