Today we will resolve problem which we had during export data from 10.2.04 database with expdp utility
We was trying epxort data with this command :
expdp scott/scott DIRECTORY=scott DUMPFILE=scott.dmp LOGFILE=scott.log SHEMAS=SCOTT
But unfortunately we got a message like this
drop ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SCOTT
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
Resolve of problem
Cause of problem is public synonym with the same name as the user schema name performing the export
Find problematic synonym with command and drop it if it’s possible
select s.synonym_name
from dba_synonyms s
where s.owner = 'PUBLIC'
and s.synonym_name = SCOTT