首页 > 数据库 > oracle10g通过oem导入导出

oracle10g通过oem导入导出

2009年3月21日 亲亲宝宝 发表评论 阅读评论

ORA-20204: User does not exist: SCOTT
ORA-06512: at “SYSMAN.MGMT_USER”, line 121
ORA-06512: at “SYSMAN.MGMT_JOBS”, line 109
ORA-06512: at “SYSMAN.MGMT_JOBS”, line 48
ORA-06512: at line 1
CAUSE
—–
The user SCOTT does not have the privileges (such as MGMT_USER) to submit
the job.
In the Enterprise Manager Console, add the user who will run the Export/Import
DataPump job as an Administrator who can login to Enterprise Manager to perform
management tasks like set Blackouts, email notification schedules.
– login as user SYSTEM (or user SYS) to the ‘Enterprise Manager 10g
Database Control’
– At the top right, click on the link ‘Setup’
– On the page ‘Administrators’, click on the button ‘Create’
– On the page ‘Create Administrator: Properties’, add the user who will run
the Export/Import DataPump job
– Click on the button: ‘Finish’
– On the page ‘Create Administrator: Review’, click on the button: ‘Finish’
– On the page ‘Administrators’, confirm that the user has been added.
– At the top right, click on the link ‘Logout’
Now login as the user who will run the Export/Import DataPump job (SCOTT),
and re-create the DataPump job.

分类: 数据库 标签: 2,974 次阅读
原文链接:http://www.wenhq.com/article/view_276.html
欢迎转载,请注明出处:亲亲宝宝
  1. 本文目前尚无任何评论.
  1. 本文目前尚无任何 trackbacks 和 pingbacks.