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!

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,713 views