全部博文
-
编辑 删除
dbms_parallel_execute包的介绍
此包使用去大批量数据INSERT,DELETE,UPDATE还支持MERGE 并且不锁表经过测试几乎1分钟1000万左右不过还得说必须服务器性能好1.赋权grant create job to SCOTT; grant execute on dbms_scheduler to SCOTTgrant execute on dbms_parallel_execute to SCOTT;2.包含3种形式--1?CREATE_CHUNKS_BY_ROWIDBEGIN DBM...
-
编辑 删除
dbms_scheduler.run_job报错
手工运行 begindbms_scheduler.run_job('J_PROD_CTL'); end;的时候报错ORA-03001: unimplemented featureORA-06512: at "SYS.DBMS_ISCHED", line 196ORA-06512: at "SYS.DBMS_SCHEDULER", line 486ORA-06512: at line 2后面问了别人才知道If you already created a chain job for a chain, you can us...
