Oracle 导入exp命令导出的数据时,提示“导入提交失败”


导入提交失败
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

最近在执行Oracle导入的过程中碰到这个问题,原因是执行JOB的账号没有相关的权限,通过下面的方法可以解决这个问题。

执行sqlplus / as sysdba

再执行
SQL> execute MGMT_USER.MAKE_EM_USER(‘需要执行导入的用户’);

PL/SQL procedure successfully completed.

这样子解决了上面的问题。

Advertisements

发表评论

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 更改 )

Twitter picture

You are commenting using your Twitter account. Log Out / 更改 )

Facebook photo

You are commenting using your Facebook account. Log Out / 更改 )

Google+ photo

You are commenting using your Google+ account. Log Out / 更改 )

Connecting to %s