Materialized view that doesn't run

[AnaFlorTech]

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 minutes.

If I use the select in a create table, it finishes after 5 minutes too.

Can you help me?

 

[Dagon]

What's the syntax of your create materialized view statement ? Are you running all the commands on the same database ?

Retired (not by choice) Oracle contractor.