-
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.
-
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.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|