1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Materialised Views

Discussion in 'General' started by alex2012, Jul 17, 2012.

  1. alex2012

    alex2012 Guest

    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.