Wednesday, December 17, 2014

Oracle 11g R2: export table


ORA-20446: The owner of the job is not registered
ORA-06512: at “SYSMAN.MGMT_JOBS”, line 168
ORA-06512: at “SYSMAN.MGMT_JOBS”, line 86
ORA-06512: at line 1

Cause:

This is an Oracle bug in 11g, there is a fix available, you can use following workaround:

Fix
$ sqlplus /nolog
SQL> connect sysman/<password>
SQL> execute MGMT_USER.MAKE_EM_USER('USERID');

No comments:

Post a Comment