首页 > 数据库 > 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.

No related posts.

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