problem creating materialized view

[Bobnz]

I have a select query script that runs fine. I am trying to create a mview with it but when I try to create the view,it runs and runs and never creates the view; I have to cancel. I let it run for an hour without success, the actual select query takes about 5 seconds.

create materialized view <viewname> as

select
.....
.....
)
/

 

[Beilstwh]

What is the exact materlized view command? What type of refresh are you doing? Did you generate MVIEW logs on the base tables (needed if the select isn't complex)? Does the original select take 5 seconds to START to return rows or does it take 5 seconds to return ALL rows? This question can't be answered without additional information.

Bill
Oracle DBA/Developer
New York State, USA

 

[Bobnz]

Thanks for the reply but everything sorted now.

B