Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
396 views
in Technique[技术] by (71.8m points)

oracle - ORA-00054:资源正忙并且在指定了NOWAIT的情况下进行获取或超时已过期(ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired)

Why am I getting this database error when I update a table?

(为什么更新表时出现此数据库错误?)

ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

(第1行发生错误:ORA-00054:资源繁忙,并且指定了NOWAIT进行获取或超时已过期)

  ask by sun translate from so

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

Your table is already locked by some query.

(您的表已被某些查询锁定。)

For example, you may have executed "select for update" and have not yet committed/rollbacked and fired another select query.

(例如,您可能已执行“选择更新”,但尚未提交/回滚并触发了另一个选择查询。)

Do a commit/rollback before executing your query.

(在执行查询之前执行提交/回滚。)


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...