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/[email protected]/
--------------------------------------------------------------------------------------------------------------------------__________________________________________________________________
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
