The first day of working--everything is fresh to me--I am a super person!

最新推荐文章于 2025-08-11 10:33:01 发布

henrybai

最新推荐文章于 2025-08-11 10:33:01 发布

阅读量908

点赞数

CC 4.0 BY-SA版权

文章标签： oracle table application security database 64bit

本文链接：https://blog.youkuaiyun.com/henrybai/article/details/3858496

作者在新年第一天尝试创建Oracle物化视图时遇到死锁问题，通过一段时间的努力找到了问题的根源并成功解决了该问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

I did a strange thing at the first day of the new year and Oracle gave me a foolish feedback then I took a rather long time to find the root cause about the issue.

$ sqlplus scott/tiger

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Feb 2 02:15:49 2009

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP
and Data Mining options

SQL> CREATE MATERIALIZED VIEW sgreports.summary on prebuilt table
2   REFRESH force with primary key
3   AS select *
4   FROM sgreports.summary;
CREATE MATERIALIZED VIEW sgreports.summary on prebuilt table
            *
ERROR at line 1:
ORA-04020: deadlock detected while trying to lock object
30x407DD02900x41697EB180x40BE24128

SQL> CREATE MATERIALIZED VIEW summary on prebuilt table
2   REFRESH force with primary key
3   AS select *
4   FROM sgreports.summary;

Materialized view created.

I took time to find what has caused the deadlock,sound like joke,isn't it:)

The first day of working--everything is fresh to me--I am a super person!