|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
[oracle@bdora]$ time impdp system/senha schemas=Nome directory=BKPDIR dumpfile=NOME_SCHEMA.dmp logfile=impNovo.log EXCLUDE=STATISTICS Import: Release 11.2.0.2.0 - Production on Tue Apr 24 10:12:49 2018 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production ORA-31626: job does not exist ORA-31633: unable to create master table "SYSTEM.SYS_IMPORT_SCHEMA_06" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT", line 1020 ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM real 0m0.397s user 0m0.022s sys 0m0.022s |
Visualizando eventos ddl
|
1 2 |
SYS@XE > select owner, object_name, object_type, status from dba_objects where lower(object_name) like '%evs_monitoring_ddl'; no rows selected |
Verificando fila de execução datapump
|
1 2 3 4 5 6 |
column owner_name format a20; column job_name format a20; column operation format a10; column job_mode format a10; column state format a15; column attached_sessions format a10; |
|
1 2 3 4 5 6 |
SYS@XE > SELECT owner_name, job_name, operation, job_mode, state, attached_sessions FROM dba_datapump_jobs; OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE ATTACHED_SESSIONS -------------------- -------------------- ---------- ---------- --------------- ----------------- SYSTEM SYS_IMPORT_SCHEMA_01 IMPORT SCHEMA NOT RUNNING ########## |
Dropando table system.SYS_IMPORT_SCHEMA_01
|
1 2 |
SYS@XE > drop table system.SYS_IMPORT_SCHEMA_01; Table dropped. |
Verificando Jobs
|
1 2 |
SYS@XE > select owner_name,job_name,operation,job_mode,state,attached_sessions from dba_datapump_jobs; no rows selected |