Posted on 2012-09-17
Last Modified: 2012-09-18
i have a materialied view in my database.
After an import of dababase i cannot execute refresh
i get the following errors :

ORA-00942: table or view not exist
ORA-06512: a "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: a "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: a "SYS.DBMS_SNAPSHOT", line 2430
ORA-06512: a line 2

Then if i drop and create the materialized view in my database everything work.
There's a my mistake in import dump operation?
Question by:NUCLEARE
    1 Comment
    LVL 20

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    Number Format 1 29
    Add 0 to end of Number 21 58
    oracle query 15 56
    Join SQL view with APEX item as the join condition 4 27
    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now