You could try creating the table the mv will be based on, then creating the mv "on existing table". Might work
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules