OraFAQ Forum: Server Administration » Materialized view creation error (merged)

Home » RDBMS Server » Server Administration » Materialized view creation error (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Materialized view creation error (merged) [message #340763]

Thu, 14 August 2008 03:44

gajini
Messages: 262
Registered: January 2006

Senior Member

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..

[Updated on: Thu, 14 August 2008 04:43]

Report message to a moderator

Re: Object doesn't exist [message #340780 is a reply to message #340763]

Thu, 14 August 2008 04:48

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

check whether there is any table with that name or not??

Report message to a moderator

Re: Object doesn't exist [message #340782 is a reply to message #340763]

Thu, 14 August 2008 04:51

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You didn't post the statement you used to get the first error.

Regards
Michel

Report message to a moderator

Re: Object doesn't exist [message #341241 is a reply to message #340780]

Sun, 17 August 2008 23:32

gajini
Messages: 262
Registered: January 2006

Senior Member

Hi Tanmoy,

Yes there's a table exist with the same name.Then how can i create the materialized view with the same name?

Thanks...

Report message to a moderator

Re: Object doesn't exist [message #341245 is a reply to message #341241]

Sun, 17 August 2008 23:38

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

simply u cant do that. rename your table or rename your view. so far I know Smile

Report message to a moderator

Materialized view creation error [message #341261 is a reply to message #340763]

Mon, 18 August 2008 00:58

gajini
Messages: 262
Registered: January 2006

Senior Member

Hi,

When creating the materialized view,I'm getting the following error,please help me to resolve this error.

>create materialized view mv_dept
2 build immediate
3 refresh force on commit
4 as
5 select deptno, count(*) sum_sal
6 from dept
7 group by deptno;
from dept
*
ERROR at line 6:
ORA-00955: name is already used by an existing object

Thanks..

Report message to a moderator

Re: Materialized view creation error [message #341263 is a reply to message #341261]

Mon, 18 August 2008 01:40

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Either a materialized view or a table of same name already existed.
Check user_objects.

please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter).
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel

[Updated on: Mon, 18 August 2008 01:40]

Report message to a moderator

Re: Materialized view creation error [message #341265 is a reply to message #341261]

Mon, 18 August 2008 01:42

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why do you repost the same question?

Regards
Michel

[Updated on: Mon, 18 August 2008 01:43]

Report message to a moderator

Re: Materialized view creation error (merged) [message #398063 is a reply to message #340763]

Wed, 15 April 2009 02:00

sunil bhola
Messages: 58
Registered: July 2002

Member

when a materialized view is created it creates two objects

1.a materialized view
2.a table

try to drop both before recreating

Report message to a moderator

Re: Materialized view creation error (merged) [message #398072 is a reply to message #398063]

Wed, 15 April 2009 02:31

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello Sunil,

Thanks for your response.

But this is very old thread. Before replying did you check last reply date ?? ("Mon, 18 August 2008 01:42")

babu

Report message to a moderator

Previous Topic:	How to get metalink support
Next Topic:	DB is Down!! ORA-00472: PMON process terminated with error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 17:38:19 CST 2024