DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Object doesn't exist

Threaded View

  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.

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