{"id":186,"date":"2018-04-24T11:01:58","date_gmt":"2018-04-24T14:01:58","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=186"},"modified":"2018-04-24T11:01:58","modified_gmt":"2018-04-24T14:01:58","slug":"datapump-erro-ora-31633-unable-to-create-master-table-system-sys_import_schema_06","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2018\/04\/24\/datapump-erro-ora-31633-unable-to-create-master-table-system-sys_import_schema_06\/","title":{"rendered":"DataPump erro ORA-31633: unable to create master table &#8220;SYSTEM.SYS_IMPORT_SCHEMA_06&#8221;"},"content":{"rendered":"<pre class=\"lang:sh decode:true\">[oracle@bdora]$ time impdp system\/senha schemas=Nome directory=BKPDIR dumpfile=NOME_SCHEMA.dmp logfile=impNovo.log EXCLUDE=STATISTICS\n\nImport: Release 11.2.0.2.0 - Production on Tue Apr 24 10:12:49 2018\n\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\n\nConnected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production\nORA-31626: job does not exist\nORA-31633: unable to create master table \"SYSTEM.SYS_IMPORT_SCHEMA_06\"\nORA-06512: at \"SYS.DBMS_SYS_ERROR\", line 95\nORA-06512: at \"SYS.KUPV$FT\", line 1020\nORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM\n\nreal    0m0.397s\nuser    0m0.022s\nsys     0m0.022s<\/pre>\n<p>Visualizando eventos ddl<\/p>\n<pre class=\"lang:plsql decode:true\">SYS@XE &gt; select owner, object_name, object_type, status from dba_objects where lower(object_name) like '%evs_monitoring_ddl';\nno rows selected<\/pre>\n<p>Verificando fila de execu\u00e7\u00e3o datapump<\/p>\n<pre class=\"lang:plsql decode:true \">column owner_name format a20;\ncolumn job_name format a20;\ncolumn operation format a10;\ncolumn job_mode format a10;\ncolumn state format a15;\ncolumn attached_sessions format a10;<\/pre>\n<pre class=\"lang:plsql decode:true \">SYS@XE &gt; SELECT owner_name, job_name, operation, job_mode, state, attached_sessions\nFROM dba_datapump_jobs;\n\nOWNER_NAME           JOB_NAME             OPERATION  JOB_MODE   STATE           ATTACHED_SESSIONS\n-------------------- -------------------- ---------- ---------- --------------- -----------------\nSYSTEM               SYS_IMPORT_SCHEMA_01 IMPORT     SCHEMA     NOT RUNNING            ##########<\/pre>\n<p>Dropando table system.SYS_IMPORT_SCHEMA_01<\/p>\n<pre class=\"lang:plsql decode:true\">SYS@XE &gt; drop table system.SYS_IMPORT_SCHEMA_01;\nTable dropped.<\/pre>\n<p>Verificando Jobs<\/p>\n<pre class=\"lang:default decode:true \">SYS@XE &gt; select owner_name,job_name,operation,job_mode,state,attached_sessions from dba_datapump_jobs;\nno rows selected<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[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 &#8211; 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 &#8211; 64bit Production ORA-31626: job does not exist ORA-31633: unable to create master table &#8220;SYSTEM.SYS_IMPORT_SCHEMA_06&#8243;&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[217,231,255,256],"class_list":["post-186","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-ora-01658","tag-ora-06512","tag-ora-31626","tag-ora-31633"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=186"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/186\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}