ORA-00054 资源正忙 "resource busy and acquire with NOWAIT specified"错误
ORA-00054 资源正忙 "resource busy and acquire with NOWAIT specified"错误 [oracle@mlab2 data]$ oerr ora 00054 00054, 00000, "resource busy and acquire with NOWAIT specified or timeout expired" // *Cause: In...
最近需要是使用Oracle Job,以前搞的现在都生疏了,还是准备整理好把知识留下来,下面是一个备份短信日志的Job的处理过程。第一部分:简单创建一个任务
1、创建存储过程
create or replace procedure proc_backup_sendmessagelog is
backuptime date :=sysdate;
begin
/*新增*/
i...