- 论坛徽章:
- 0
|
数据库版本10201使用OEM的从导出文件导入功能使用SYSTEM用户导入,结果出现了这个错误:
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
ORA-39083: Object type PROCOBJ failed to create with error:
ORA-27486: insufficient privileges
Failing sql is:
BEGIN
dbms_scheduler.create_job('"ADV_SEGMENTADV_752656"',
job_type=>'PLSQL_BLOCK', job_action=>
'DECLARE
taskname varchar2(100);
BEGIN
tas
kname := ''SEGMENTADV_752656'';
dbms_advisor.reset_task(taskname);
dbms_advisor.execute_task(taskname);
END;'
, number_of_arguments=>0,
start_date=>'20-AUG-07 03.04.38.119391 PM +08:00', repeat_interval=>
NULL
, end_date=>NULL,
job_class=>'"DEFAULT_JO
Job "SYSTEM"."IMPORT000303" completed with 1 error(s) at 11:04:54
Execution errors encountered.
Job state: COMPLETED
请大家帮忙看看
[ 本帖最后由 pingstream 于 2008-8-7 11:31 编辑 ] |
|