Ainda não mestre, como deu só esses dois erros, irei importar mesmo assim para um database de homologação que tenho, caso o pessoal reclame tento resolver o problema, só fiquei sem saber o que danado é isso :/ sys@TRF5PRD> select comp_id,version,status from dba_registry; COMP_ID VERSION STATUS ------------------------------ ------------------------------ ----------- OWB 11.2.0.3.0 VALID APEX 3.2.1.00.12 VALID EM 11.2.0.3.0 VALID AMD 11.2.0.3.0 VALID SDO 11.2.0.3.0 VALID ORDIM 11.2.0.3.0 VALID XDB 11.2.0.3.0 VALID CONTEXT 11.2.0.3.0 VALID EXF 11.2.0.3.0 VALID RUL 11.2.0.3.0 VALID OWM 11.2.0.3.0 VALID CATALOG 11.2.0.3.0 VALID CATPROC 11.2.0.3.0 VALID JAVAVM 11.2.0.3.0 VALID XML 11.2.0.3.0 VALID CATJAVA 11.2.0.3.0 VALID APS 11.2.0.3.0 VALID XOQ 11.2.0.3.0 VALID SELECT owner, COUNT(*) FROM dba_objects where status = 'INVALID' GROUP BY owner; Nada consta, tudo valido também.
Em Quarta-feira, 13 de Novembro de 2013 8:37, Emerson dos Santos Gaudêncio <[email protected]> escreveu: 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? >
