To improve performance in my application I have succesfully done so using a materialised view. The only problem I am now facing is that when I export a database from one user (view is exported as well) and I try to import this database to another user, the view doesn't change to that user but instead complains that the view already exists. What I desperately need is an easier way (like the commandline "imp" ) to import this view into another user instead of having to create the view again. Or maybe I am doing something entirely wrong creating the materialised view and that is why I cannot auto import the view correctly. Can anyone help me with this ? Many Thanks.