7 Replies Latest reply: Aug 22, 2014 10:12 PM by Srini Chavali-Oracle RSS

    Errors in expdp full ORA-39127 ORA-06502 ORA-06512

    2734390

      Export: Release 10.2.0.2.0 - Production on Friday, 15 August, 2014 12:31:11

       

       

      Copyright (c) 2003, 2005, Oracle.  All rights reserved.

      ;;;

      Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

      With the Partitioning, OLAP and Data Mining options

      Starting "JDAYRIT"."SYS_EXPORT_FULL_01":  jdayrit/******** full=Y directory=DATA_DUMP_DIR_FULL dumpfile=ODS1FULL.dmp logfile=expdpODS1FULL.log

      Estimate in progress using BLOCKS method...

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

      Total estimation using BLOCKS method: 375.2 GB

      Processing object type DATABASE_EXPORT/TABLESPACE

      Processing object type DATABASE_EXPORT/SYS_USER/USER

      Processing object type DATABASE_EXPORT/SCHEMA/USER

      Processing object type DATABASE_EXPORT/ROLE

      Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT

      Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT

      Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT

      Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE

      Processing object type DATABASE_EXPORT/PROXY

      Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA

      Processing object type DATABASE_EXPORT/RESOURCE_COST

      Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK

      Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK

      Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE

      Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY

      Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/CROSS_SCHEMA/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/CONTEXT

      Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM

      Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM

      Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC

      Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM

      Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM

      Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA

      ORA-39127: unexpected error from call to export_string := SYS.DBMS_SCHED_JOB_EXPORT.create_exp(165302,'10.02.00.02.00',newblock)

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small

      ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 351

      ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 14

      ORA-06512: at line 1

      ORA-06512: at "SYS.DBMS_METADATA", line 5038

      ORA-39127: unexpected error from call to export_string := SYS.DBMS_SCHED_JOB_EXPORT.create_exp(174891,'10.02.00.02.00',newblock)

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small

      ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 351

      ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 14

      ORA-06512: at line 1

      ORA-06512: at "SYS.DBMS_METADATA", line 5038

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT

      Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC

      Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION

      Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE

      Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION

      Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE

      Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW

      Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/CROSS_SCHEMA/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT

      Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY

      Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER

      Processing object type DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER

      Processing object type DATABASE_EXPORT/SCHEMA/JOB

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ

      ORA-39127: unexpected error from call to export_string := SYS.DBMS_SCHED_JOB_EXPORT.create_exp(165302,'10.02.00.02.00',newblock)

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small

      ORA-06502: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 351

      ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 14

      ORA-06512: at line 1

      ORA-06512: at "SYS.DBMS_METADATA", line 5038

      ORA-39127: unexpected error from call to export_string := SYS.DBMS_SCHED_JOB_EXPORT.create_exp(174891,'10.02.00.02.00',newblock)

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small

      ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 351

      ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 14

      ORA-06512: at line 1

      ORA-06512: at "SYS.DBMS_METADATA", line 5038

      Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ

      Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/GRANT/PROCOBJ_GRANT

      Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA

      . . exported "PLLDBA"."ACTL_LOTPARAMETERS"               30.82 GB 612141119 rows

      . . exported "PLLDBA"."EQPS_COMMENTS"                    15.91 GB 353368521 rows

       

       

      Errors encountered during expdp full. How to fix these?

      I am using Oracle 10g on Windows (Oracle Database 10g Enterprise Edition Release 10.2.0.2.0)

       

       

      Thank you