DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DataPump error while export

  1. #1
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340

    DataPump error while export

    Hi All,

    while exporting using datapump i am facing the below error.
    can somebody suggest


    ORA-39127: unexpected error from call to export_string :=SYS.LT_EXPORT_PKG.schema_info_exp('SYS',1,1,'10.02.00.00.00',newbloc
    k)
    ORA-04031: unable to allocate 46640 bytes of shared memory ("shared pool","LTADM","PL/SQL MPCODE","BAMIMA: Bam Buffer")
    ORA-06508: PL/SQL: could not find program unit being called: "SYS.LTADM"
    ORA-06512: at "SYS.LT_EXPORT_PKG", line 843
    ORA-06512: at line 1
    ORA-06512: at "SYS.DBMS_METADATA", line 5419
    Thanks/Gopu

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Does ever expdp worked on affected instance?
    Is SYS.LT_EXPORT_PKG package body valid?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    yes it is valid

    OWNER OBJECT_NAME OBJECT_TYPE STATUS CREATED TO_CHAR(LAST_DDL_T
    --------------- -------------------------------- --------------- ------- --------- ------------------
    SYS LT_EXPORT_PKG PACKAGE VALID 25-OCT-07 25-10-200713:44:49
    SYS LT_EXPORT_PKG PACKAGE BODY VALID 25-OCT-07 25-10-200713:44:41
    Thanks/Gopu

  4. #4
    Join Date
    Mar 2001
    Location
    India
    Posts
    57
    Expand your shared pool.
    Thanks and Regards,
    Gitesh Trivedi
    Dbametrix Solutions
    Database DBA support

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