Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Materialized View creation problem/taking long time...

james.Feb 17 2007 — edited Aug 22 2007

Hi All,

I having problem in creating Materialized view. The select statement is taking to 1 min if you run stand alone but when I try to create MV it is taking for ever. Please help me here is my script

CREATE MATERIALIZED VIEW
mv_test
BUILD IMMEDIATE REFRESH ON DEMAND WITH PRIMARY KEY AS SELECT * FROM test.

"test" is a complex view in other schema. I tried with DEFERRED and later refreshing the MV. But no luck.

Any help is appreciated .

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2007

Added on Feb 17 2007

#general-database-discussions

20 comments

10,447 views