-
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
-
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.
-
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|