`
wangpengfei360
  • 浏览: 1056429 次
文章分类
社区版块
存档分类
最新评论

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

 
阅读更多

I did astrange thing at the first day of the new year and Oracle gave me a foolish feedback then I took a rather long timeto 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

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


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!

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics