Pular para o conteúdo

Fóruns Banco de dados Oracle Importação banco para outro banco oracle 10g x64 Importação banco para outro banco oracle 10g x64

#105517
Julian
Participante

    @rman

    tentei como vc disse e não rolou

    fiz isso :

    servidor antigo : expdp dumpfile=backup.dmp logfile=backup.log full=y

    servidor novo : criei as tablespace igual ao servidor antigo e uma role :
    create role “ROLE_MEGA” ;
    SCHEMAS=MEGA,METRO,MGACA,MGACE,MGADM,MGADO,MGAGR,MGATI,MGBEN,MGBI,MGCAC,MGCAP,MGCAR,MGCAV,MGCGI,MGCI,MGCLI,MGCMR,MGCON,MGCQL,MGCRR,MGCSC,MGCSL,MGCSP,MGCSZ,MGCTO,MGCTT,MGCUSTOM,MGCWB,MGDBM,MGDSP,MGEMP,MGEXP,MGFIN,MGFRO,MGGEO,MGGIA,MGGLO,MGIA,MGINS,MGINT,MGITU,MGLOJ,MGMAG,MGMAN,MGMETRO,MGMI,MGMST,MGMTI,MGNFE,MGNFS,MGORC,MGPARTNER,MGPAT,MGPCQ,MGPET,MGPGC,MGPGE,MGPGE2,MGPGO,MGPGW,MGPHO,MGPON,MGPROJ,MGPSC,MGPSM,MGPUC,MGREC,MGREL,MGRH,MGRMT,MGSATCO,MGTMK,MGTRA,MGTRF,MGTSK,MGUBC,MGVEN,MGVINICIUS,MGWEB,MGWWW,MRBAL DUMPFILE=backup.dmo logfile=import.log

    log, somente da parte de erro :

    Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
    Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/WITH_GRANT_OPTION/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
    ORA-39082: Object type ALTER_FUNCTION:”MEGA”.”PROXIMASEQUENCIAORG” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MEGA”.”ACHASEQUENCIADATABELA” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MEGA”.”ACHAPADRAODATABELA” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGRH”.”FILTRACARACTER” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGFIN”.”F_VARIACAOCAMBIAL” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGFIN”.”F_RENDIMENTO” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGADM”.”F_CUSTO_PRODUTO” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGADM”.”F_VALIDAFORNECEDOR” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGADM”.”F_SOMA_VALOR_SAI” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGADM”.”F_SOMA_VALOR_ENT_CP” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGVEN”.”F_BUSCAPERCDESC” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGATI”.”F_SALDOGRUPODEP” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGATI”.”F_SALDOGRUPOCORR” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGRH”.”CALCULAGFIP” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGRH”.”CALCULARETENCAO” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGRH”.”ELIMINAEVENTO” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGRH”.”EMFERIAS” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGRH”.”PODEPAREAREVENTO” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGRH”.”F_INFORMERENDIMENTOPENSAO” created with compilation warnings
    ORA-39082: Object type ALTER_FUNCTION:”MGRH”.”F_INFORMERENDIMENTOPENSAO_RET” created with compilation warnings
    Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
    ORA-39082: Object type ALTER_PROCEDURE:”MGCON”.”P_CONVERTECRITERIO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGCON”.”P_SALDOSRAZAO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGFIN”.”P_SOMAVALORESIR” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGFIN”.”P_ATUALIZASALDOFLUXO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGFIN”.”P_CURSORAGRUPAMOVTOBXCPA” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGFIN”.”P_RENDIMENTODETALHE” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGFIN”.”P_CALCULACONTRIB” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGFIN”.”P_AJUSTAVRRATEIO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGFIN”.”P_GERADIRFJ” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGFIN”.”P_CURSORAGRUPAMOVTO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGFIN”.”P_GERADIRFF” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGFIN”.”P_CURSORAGRUPAMOVTOCRE” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGFIN”.”P_CURSORAGRUPAMOVTOBXCRE” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGFIN”.”P_RENDIMENTO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGADM”.”P_GERARELKARDEX” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGADM”.”P_GERARELP7″ created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGVEN”.”SP_TABELAPRECO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGVEN”.”SP_COMISSAO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGTRF”.”P_INFORMERENDIMENTOPENSAO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGLOJ”.”SP_FECHAMENTOCAIXA” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGORC”.”P_CONVERTECRITERIO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”GFIPREG32″ created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”P_DIVERGENCIAPROJCC” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”PAREAREVENTOSRECIBO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”GFIPREG00″ created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”GFIPREG10″ created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”GFIPREG12″ created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”GFIPREG13″ created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”GFIPREG14″ created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”GFIPREG20″ created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”GFIPREG30″ created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”PAREAREVENTOS” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”TOTALIZARFOLHA” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”P_RAISORG” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”P_ESTRUTURACONTABIL” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”PAREAREVENTOSCRITERIO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”PAREAREVENTOSPROJCC” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”PAREARRECIBO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”DEMONSTRATIVOMEDIA” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”CAGED” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”GFIPREG30FIL” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”PAREAREVENTOSFERIAS” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGPON”.”P_RELIRREGANALITICO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGREL”.”P_CONFERENCIAGFIP” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGREL”.”ORC_P_RAZAO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGREL”.”P_REGAPURMODELO9″ created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”P_RAISDADOSAFASTAMENTO” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”P_CONFDIVERGENCIA” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”P_RAISCONFERENCIA” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”GFIPREG21″ created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”P_CONFINTFINANC” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGTRF”.”P_INFORMERENDIMENTOPENSAO_RET” created with compilation warnings
    ORA-39082: Object type ALTER_PROCEDURE:”MGRH”.”P_ATUALIZABRUTORAIS” created with compilation warnings
    Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
    ORA-39082: Object type VIEW:”MGGLO”.”GLO_VW_LOGSQL” created with compilation warnings
    Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/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
    ORA-39082: Object type PACKAGE_BODY:”MGTRF”.”TRF_PCK_ATOCOTEPE” created with compilation warnings
    ORA-39082: Object type PACKAGE_BODY:”MGMAG”.”MAG_PCK_MANAD” created with compilation warnings
    ORA-39082: Object type PACKAGE_BODY:”MGMAG”.”MAG_PCK_SPEDFISCAL” created with compilation warnings
    ORA-39082: Object type PACKAGE_BODY:”MGINT”.”INT_PCK_MAGEXECUCAO” created with compilation warnings
    ORA-39082: Object type PACKAGE_BODY:”MGMAG”.”MAG_PCK_EFD_VALIDACAO” created with compilation warnings
    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
    ORA-39082: Object type TRIGGER:”MGGLO”.”GLO_TRA_ATUALIZASINCRONISMO” created with compilation warnings
    ORA-39082: Object type TRIGGER:”MGGLO”.”GLO_TRA_ATUALIZASINCRONISMO” created with compilation warnings
    ORA-39082: Object type TRIGGER:”MGGLO”.”GLO_TRB_SCRIPTSQL” created with compilation warnings
    ORA-39082: Object type TRIGGER:”MGGLO”.”GLO_TRB_SCRIPTSQL” created with compilation warnings
    Processing object type DATABASE_EXPORT/SCHEMA/TABLE/MATERIALIZED_VIEW_LOG
    Job “SYSTEM”.”SYS_IMPORT_SCHEMA_01″ completed with 83 error(s) at 12:41:22