impdp的时候遇到错误:
drop ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user U1
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-6512: at "SYS.KUPV$FT", line 1201
ORA-39062: error creating master process DM00
ORA-39107: Master process DM00 violated startup protocol. Master error:
ORA-6533: Subscript. beyond count
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user U1
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-6512: at "SYS.KUPV$FT", line 1201
ORA-39062: error creating master process DM00
ORA-39107: Master process DM00 violated startup protocol. Master error:
ORA-6533: Subscript. beyond count
该错误是 因为导出的同义词和schemas名字一样照成的
解决方法:打patch或是使得 同义词的名字与schemas不一样
In this Document
Symptoms
Cause
Solution
References
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 and later [Release: 10.1 and later ]Oracle Server - Enterprise Edition - Version: 10.1.0.2 and later [Release: 10.1 and later]
Information in this document applies to any platform.
Symptoms
When running EXPDP the following errors are raised:
expdp u1/u1 DIRECTORY=test_dp DUMPFILE=export_schemas.dmp
Export: Release 10.2.0.4.0 - Production on Thursday, 01 October, 2009 10:13:54
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
- Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
drop ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user U1
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-6512: at "SYS.KUPV$FT", line 1201
ORA-39062: error creating master process DM00
ORA-39107: Master process DM00 violated startup protocol. Master error:
ORA-6533: Subscript. beyond count
Export: Release 10.2.0.4.0 - Production on Thursday, 01 October, 2009 10:13:54
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
- Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
drop ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user U1
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-6512: at "SYS.KUPV$FT", line 1201
ORA-39062: error creating master process DM00
ORA-39107: Master process DM00 violated startup protocol. Master error:
ORA-6533: Subscript. beyond count
Cause
The cause of this problem has been identified in Bug:8979456. It is caused by the existence of a public synonym with the same name as the user schema name performing the export or import operation.This can be checked with:
connect / as sysdba
select s.synonym_name
from dba_synonyms s, dba_users u
where s.owner = 'PUBLIC'
and s.synonym_name = u.username;
select s.synonym_name
from dba_synonyms s, dba_users u
where s.owner = 'PUBLIC'
and s.synonym_name = u.username;
This problem can happen with both EXPDP and IMPDP. The issue occurs irrespective of whether the export or import operation is a table, schema, or database level action.
Solution
When available, download Patch 8979456 to resolve this issue.Note that this patch was not available at the time of writing this document (DEC 2010).
The workaround is to make sure that no public synonym exists with a name which matches a schema name in the database.
References
BUG:8979456 - EXPDP/IMPDP TERMINATE WITH ORA-06533: SUBSCRIPT. BEYOND COUNT来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24849178/viewspace-732766/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24849178/viewspace-732766/