逻辑备库上创建JOB报ORA-01031错误

郑全

在逻辑备库上创建任何JOB，包含使用SYS用户去创建，都会报这个：
ora-01031
ora-06152 SYS.DBMS_INTERNAL_LOGSTDBY
...


经确认，这个是ORACLE故意这样设计的。
创建job的时候job的id是oracle自动编号的，所以如果允许的话，可能会引起主库和LOGICAL STANDBY库上的ID冲突


Oracle PL/SQL supplied packages that modify system metadata typically are not
supported by SQL Apply, and therefore their effects are not visible on the logical
standby database. Examples of such packages are DBMS_JAVA, DBMS_REGISTRY,
DBMS_ALERT, DBMS_SPACE_ADMIN, DBMS_REFRESH, DBMS_REDEFINITION, DBMS_
SCHEDULER, and DBMS_AQ.
Specific support for DBMS_JOB has been provided. Job execution is suspended on a
logical standby database and jobs cannot be scheduled directly on the standby
database. However, jobs submitted on the primary database are replicated in the
standby database. In the event of a switchover or failover, jobs scheduled on the
original primary database will automatically begin running on the new primary
database