Rafael,

Já tentou exportar somente os metadados dos schemas? para testar ?

Att,
Emerson


2013/11/13 Rafael Mendonca <[email protected]>

>
>
> Bom dia!
>
>
> BANNER
>
> --------------------------------------------------------------------------------
> Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
> Production
> PL/SQL Release 11.2.0.3.0 - Production
> CORE    11.2.0.3.0      Production
> TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
> NLSRTL Version 11.2.0.3.0 - Production
>
>
>
> expdp system/******** schemas=XUXA1,XUXA2 directory=DATA_PUMP_DIR
> dumpfile=XUXA.dmp logfile=XUXA.log
>
>
> O erro aconteceu no decorrer do expdp, mas não abortou o processo, o expdp
> continua rodando, mas não entendi o erro abaixo:
>
> ...
> Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
> ORA-39127: unexpected error from call to export_string :=
> SYS.DBMS_SCHED_PROGRAM_EXPORT.CREATE_EXP(595384,'11.02.00.00.00',newblock)
> ORA-06502: PL/SQL: numeric or value error: character string buffer too
> small
> ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 182
> ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 561
> ORA-06512: at "SYS.DBMS_SCHED_PROGRAM_EXPORT", line 14
> ORA-06512: at line 1
> ORA-06512: at "SYS.DBMS_METADATA", line 8775
> Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
> ...
> ....
> ....
> Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
> ORA-39127: unexpected error from call to export_string :=
> SYS.DBMS_SCHED_PROGRAM_EXPORT.CREATE_EXP(595384,'11.02.00.00.00',newblock)
> ORA-06502: PL/SQL: numeric or value error: character string buffer too
> small
> ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 182
> ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 561
> ORA-06512: at "SYS.DBMS_SCHED_PROGRAM_EXPORT", line 14
> ORA-06512: at line 1
> ORA-06512: at "SYS.DBMS_METADATA", line 8775
> Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJProcessing object
> type SCHEMA_EXPORT/MATERIALIZED_VIEW
> ORA-39127: unexpected error from call to export_string :=
> SYS.DBMS_SCHED_PROGRAM_EXPORT.CREATE_EXP(595384,'11.02.00.00.00',newblock)
> ORA-06502: PL/SQL: numeric or value error: character string buffer too
> small
> ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 182
> ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 561
> ORA-06512: at "SYS.DBMS_SCHED_PROGRAM_EXPORT", line 14
> ORA-06512: at line 1
> ORA-06512: at "SYS.DBMS_METADATA", line 8775
> Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
>
>
>
> Alguém poderia ajudar?
>
>
>  
>

Responder a