|
-
Thanks for all of your help, I login as b2e54_m ( has dba privilege) to run submitting dbms_job.
SQL> show user
USER is "B2E54_M"
SQL> var v_jobnum number
SQL> begin
2 DBMS_JOB.SUBMIT(:v_jobnum,'DBMS_UTILITY.ANALYZE_SCHEMA ("B2E54_M", "COMPUTE");',
3 SYSDATE +1/24, 'trunc(sysdate+1) +1/6');
4 commit;
5 end;
6 /
begin
*
ERROR at line 1:
ORA-06550: line 1, column 122:
PLS-00201: identifier 'B2E54_M' must be declared
ORA-06550: line 1, column 93:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 131
ORA-06512: at line 2
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|