Bom Dia Pessoal Fiz um export(full) da base utilizando o expdp. Deu certo, ou seja, verificando o log estava tudo ok. Para testar a importação apaguei os objetos do esquema e fiz o impdp conforme descrito abaixo: impdp user parfile=impdpger.par
Parâmetros do arquivo impdpger.par: DIRECTORY=DTPUMP JOB_NAME=IMPGER DUMPFILE=DMPGER.DMP (gerado pelo expdp) LOGFILE=IMPGER.LOG SCHEMAS=BDGER (quero importar apenas esse esquema. O user BDGER já está criado) CONTENT=ALL STATUS=5 ******* Mensagens que aparecem no prompt: ********* C:\Bkp_Oracle>IMPDP OPERADOR PARFILE=IMPDPGER.PAR Import: Release 10.1.0.2.0 - Production on Thursday, 03 August, 2006 9:21 Copyright (c) 2003, Oracle. All rights reserved. Password: Connected to: Oracle Database 10g Release 10.1.0.2.0 - Production ORA-31655: no data or metadata objects selected for job ORA-39039: Schema expression "IN ('BDGER')" contains no valid schemas. Job: IMPGER Operation: IMPORT Mode: SCHEMA State: EXECUTING Bytes Processed: 0 Current Parallelism: 1 Job Error Count: 0 Dump File: F:\BKP_DATAPUMP\DMPGER.DMP Worker 1 Status: State: WORK WAITING Master table "OPERADOR"."IMPGER" successfully loaded/unloaded Job: IMPGER Operation: IMPORT Mode: SCHEMA State: STOPPING Bytes Processed: 0 Current Parallelism: 1 Job Error Count: 0 Dump File: F:\BKP_DATAPUMP\DMPGER.DMP Worker 1 Status: State: WORK WAITING Starting "OPERADOR"."IMPGER": OPERADOR/******** PARFILE=IMPDPGER.PAR Job: IMPGER Operation: IMPORT Mode: SCHEMA State: STOPPING Bytes Processed: 0 Current Parallelism: 1 Job Error Count: 0 Dump File: F:\BKP_DATAPUMP\DMPGER.DMP Worker 1 Status: State: WORK WAITING ----- PL/SQL Call Stack ----- object line object handle number name 681EEE54 13460 package body SYS.KUPW$WORKER 681EEE54 5810 package body SYS.KUPW$WORKER 681EEE54 6459 package body SYS.KUPW$WORKER 681EEE54 1208 package body SYS.KUPW$WORKER 67FD5E00 2 anonymous block Job: IMPGER Operation: IMPORT Mode: SCHEMA State: STOPPED Bytes Processed: 0 Current Parallelism: 1 Job Error Count: 0 Dump File: F:\BKP_DATAPUMP\DMPGER.DMP Worker 1 Status: State: WORK WAITING Job "OPERADOR"."IMPGER" stopped due to fatal error at 09:21 C:\Bkp_Oracle> ***** Texto do arquivo de log: ****** ;;; Import: Release 10.1.0.2.0 - Production on Thursday, 03 August, 2006 9:21 Copyright (c) 2003, Oracle. All rights reserved. ;;; Connected to: Oracle Database 10g Release 10.1.0.2.0 - Production Master table "OPERADOR"."IMPGER" successfully loaded/unloaded ORA-39039: Schema expression "IN ('BDGER')" contains no valid schemas. ORA-31655: no data or metadata objects selected for job Starting "OPERADOR"."IMPGER": OPERADOR/******** PARFILE=IMPDPGER.PAR ORA-39125: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS while calling SYS.DBMS_INTERNAL_SAFE_SCN.SCN.SET_SESSION_STATE [TABLE_DATA:"OPERADOR"."IMPGER"] ORA-00439: feature not enabled: Streams Capture ----- PL/SQL Call Stack ----- object line object handle number name 681EEE54 13460 package body SYS.KUPW$WORKER 681EEE54 5810 package body SYS.KUPW$WORKER 681EEE54 6459 package body SYS.KUPW$WORKER 681EEE54 1208 package body SYS.KUPW$WORKER 67FD5E00 2 anonymous block Job "OPERADOR"."IMPGER" stopped due to fatal error at 09:21 A versão é Oracle 10g Standard One 10.1.0.2 - Windows 2003. O user operador tem as roles imp_full_database e exp_full_database. Qual será o problema ? Onde posso encontrar material sobre o Data Pump Export e Import e sobre o RMAN ? Agradeço desde já Ana Patricia -------------------------------------------------------------------------------------------------------------------------- Atenção! As mensagens deste grupo são de acesso público e de inteira responsabilidade de seus remetentes. Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ --------------------------------------------------------------------------------------------------------------------------__________________________________________________________________ OPORTUNIDADES DE TRABALHO, VAGAS, EMPREGOS PARA PROFISSIONAIS ORACLE VISITE: http://www.oraclebr.com.br/ __________________________________________________________________ O grupo Oracle_br não aceita anexos. Quando oferecer algum arquivo, tenha o link do mesmo para evitar trafego(pedidos) desnecessário. Links do Yahoo! Grupos <*> Para visitar o site do seu grupo na web, acesse: http://br.groups.yahoo.com/group/oracle_br/ <*> Para sair deste grupo, envie um e-mail para: [EMAIL PROTECTED] <*> O uso que você faz do Yahoo! Grupos está sujeito aos: http://br.yahoo.com/info/utos.html