Home » RDBMS Server » Server Administration » Materialized view creation error (merged)
Materialized view creation error (merged) [message #340763] Thu, 14 August 2008 03:44 Go to next message
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 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
check whether there is any table with that name or not??
Re: Object doesn't exist [message #340782 is a reply to message #340763] Thu, 14 August 2008 04:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't post the statement you used to get the first error.

Regards
Michel
Re: Object doesn't exist [message #341241 is a reply to message #340780] Sun, 17 August 2008 23:32 Go to previous messageGo to next message
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...
Re: Object doesn't exist [message #341245 is a reply to message #341241] Sun, 17 August 2008 23:38 Go to previous messageGo to next message
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
Materialized view creation error [message #341261 is a reply to message #340763] Mon, 18 August 2008 00:58 Go to previous messageGo to next message
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..
Re: Materialized view creation error [message #341263 is a reply to message #341261] Mon, 18 August 2008 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: Materialized view creation error (merged) [message #398072 is a reply to message #398063] Wed, 15 April 2009 02:31 Go to previous message
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
Previous Topic: How to get metalink support
Next Topic: DB is Down!! ORA-00472: PMON process terminated with error
Goto Forum:
  


Current Time: Sun Nov 03 01:17:46 CDT 2024