Create Materialized View Fails with ORA-4020

Create Materialized View Fails with ORA-4020 Deadlock Detected [ID 103077.1]
	修改时间 28-SEP-2009     类型 PROBLEM     状态 PUBLISHED

 

 

Problem Description

-------------------

You are trying to create a materialized view on a prebuilt table, and

the following is reported:

ORA-04020: deadlock detected while trying to lock object

 

Error:  ORA 4020

Text:   deadlock detected while trying to lock object %s%s%s%s%s

Cause:  While trying to lock a library object, a deadlock is detected.

Action: Retry the operation later.

 

Syntax being used resembles the following format:

 

create materialized view TEST on prebuilt table

    REFRESH FAST

      as select id, col1, col2 from TEST;

       

Solution Description

--------------------

You are using the incorrect syntax to create the materialized view.

 

 

Explanation

-----------

The initial table from which the prebuilt table was created from should be the

table in the from clause.

 

Syntax example:

 

create materialized view prebuilt_table on prebuilt table

    REFRESH FAST

      as select id, col1, col2 from master_table;

 

Where the prebuilt_table = the subset table created from a larger/master table.

Where the master_table = the larger/master table of which the prebuilt_table is a subset.

 

 

References

----------

ORA-12060 WHEN ATTEMPTING TO CREATE A MATERIALIZED VIEW

 

相关的

---

产品

---

·   Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition

关键字

---

MATERIALIZED VIEW