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!
分享到:
相关推荐
The first fruits of the labor of that group became available in 1996 when the language definition of Verilog-A was released. Verilog-A was not intended to work directly with Verilog-HDL. Rather it ...
Keir Thomas, “Ubuntu Pocket Guide and Reference: A concise companion for day-to-day Ubuntu use” CreateSpace | 2009-01-19 | ISBN: 1440478295 | 166 pages | PDF | 1,95 MB Ubuntu Pocket Guide and ...
The electronics and information technology revolution continues, but it is a critical time in the development of technology. Once again, we stand on the brink of a new era where emerging research will...
高通 | augmented-and-virtual-reality-the-first-wave-of-5g-killer-apps1
(a) filling in skeleton tables of the database with examples of what is to be retrieved (b) placing SQL keywords, such as select, under the column names they want to retrieve (c) typing a ...
The first part is an introduction to the fundamental concept of a distribution and of integration with respect to a distribution. The second part contains the general theory of random variables and ...
Now, in Creating a World Without Poverty, Yunus goes beyond microcredit to pioneer the idea of social business—a completely new way to use the creative vibrancy of business to tackle social problems ...
machine can be “reduced” to the problem of determining whether a given propositional formula is a tautology. Here “reduced” means, roughly speaking, that the first problem can be solved ...
The best way to follow the flow of the book is to set up an environment, download the data, and run the applications as you go along. This will give you a taste for these real-world problems and ...
The first technique is a monotonic capacitor switching procedure. Compared to converters that use the conventional procedure, the average switching energy and total sampling capacitance are reduced by...
During the Core elections in 2002, Mark Murray stated “I am opposed to a long rule-book, as that satisfies lawyer-tendencies, and is counter to the technocentricity that the project so badly needs.”...
The purpose of this document is to define the test methodology for the RF testing of Wi-Fi mobile converged devices and to specify the test conditions for each test case. The testing covers client ...
of the BZ reaction to simulate the evolution of these spirals. The models typically use cellular automata to allow progression of a wavefront through a notional substrate. Usually a single substrate ...
With it has come vast amounts of data in avariety of fields such as medicine, biology, finance, and marketing.The challenge of understanding these data has led to the development ofnew tools in the ...
Low-Rank Adaptation (LoRA), a parameter-efficient fine-... This paper takes the first step to bridge this gap by theoretically analyzing the expressive power of LoRA. We prove that, for fully connected
This is believed to be a bug in the Windows clipboard and a work around hasn't been found yet. * Asynchronous targets appears to be broken in the current release. * When TDropFileTarget....
The main goal of this fourth edition of A First Book of C++ remains the same as in previous editions: to introduce, develop, and reinforce well-organized programming skills using C++. All topics are ...
Based on the Particle Element Method, a meso-scale dynamic model is developed for numerical study of the dynamic failure behavior of three-phase concrete i.e., aggregate, mortar, and interface, under ...
This book is the secret to unlocking your programming potentials within a very short amount of time! Learn how to program using Python, and carve your own bright future! Whether you are an expert, ...