+ Reply to Thread
Results 1 to 4 of 4
  1. 08-14-2008 04:42 AM #1
    malru
    malru is offline Member
    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.
    Reply With Quote Reply With Quote
  2. 08-14-2008 05:02 AM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,482
    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.
    Reply With Quote Reply With Quote
  3. 08-14-2008 05:29 AM #3
    malru
    malru is offline Member
    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
    Reply With Quote Reply With Quote
  4. 08-14-2008 06:18 AM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    you missed the post about looking for synonyms
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width