Object doesn't exist
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Object doesn't exist

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    Object doesn't exist

    Hi,

    When I'm trying to create a materialized view,it's saying

    ORA-00955: name is already used by an existing object

    But actually this object is not existing in my schema and i verified it by,

    > select object_name,object_type from user_objects where object_name='MV_STEPUP';
    no rows selected


    and

    >drop materialized view MV_STEPUP;
    ORA-12003: materialized view "DMUSER"."MV_STEPUP" does not exist


    Please someone help me to resolve this issue,so that I create this object.

    Thanks..
    Last edited by malru; 08-14-2008 at 05:27 AM.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by malru
    >drop materialized view MV_STEPUP;
    ORA-12003: materialized view "DMUSER"."MV_PLRNONSTEPUP_BASE_6874" does not exist
    Look for synonyms.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Feb 2006
    Posts
    162
    Hi PAVB,

    Sorry for the mistake I made during posting,it's actually MV_STEPUP only,

    ORA-12003: materialized view "DMUSER"."MV_STEPUP" does not exist

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you missed the post about looking for synonyms

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width