1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload

Discussion in 'Security, Backup and Recovery' started by d158tech, Sep 24, 2010.

  1. d158tech

    d158tech Guest

    Not sure if this is in the right forum, if not, my apologies....anyhow,

    Hello to All....Any advice or recommendations someone could give me regarding the following....I appreciate it...

    ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload
    ORA-31640: unable to open dump file "D:\oradata\PSPRODDB\data_pump_dir\powerschool-fri.dmp" for read
    ORA-19505: failed to identify file "D:\oradata\PSPRODDB\data_pump_dir\powerschool-fri.dmp"
    ORA-27046: file size is not a multiple of logical block size
    OSD-04012: file size mismatch (OS 2192117862)

    If there is more info you need, please ask.

  2. zargon

    zargon Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    Aurora, CO
    The file is likely truncated for size; you'll probably need to transfer it again after more space has been added or to a filesystem which can accomodate files larger than 2 G.