Home » Developer & Programmer » Forms » ORA-23401 materialized view "string"."string" does not exist
ORA-23401 materialized view "string"."string" does not exist [message #322966] Mon, 26 May 2008 23:45 Go to next message
sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi
Member
Dear all,
I have a menu that is connected to local schema and on that menu there is a form which is connected to remote database and on on-logon trigger of that form i have written the following code

declare
   uname varchar2(10);
   pass  varchar2(10);
   cn varchar2(30);
begin
   uname := 'apps';
   pass  := 'apps';
   cn := 'prod';
   LOGON(uname,pass||'@'||cn); 
end;


on that form i have used many snapshots which are refreshed on when-new-form-instance but it gives the ORA-23401 error.

Any help will be appreciated

Regards,
Kashif Ali
Re: ORA-23401 materialized view "string"."string" does not exist [message #322975 is a reply to message #322966] Mon, 26 May 2008 23:57 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that you are refreshing a materialized view which doesn't exist.
Oracle
ORA-23401: materialized view "string"."string" does not exist


Cause: A materialized view name was given to dbms_mview.refresh that is not in sys.snap$ or its associated views.

Action: Provide a materialized view name that is in sys.snap$, all_mviews or user_mviews.
Re: ORA-23401 materialized view "string"."string" does not exist [message #322977 is a reply to message #322975] Tue, 27 May 2008 00:00 Go to previous messageGo to next message
sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi
Member
Thanks for your reply,

but to be on the same page, should i tell the dba of that remote database to add these snapshot in sys.snap$, is it what you are saying

regards,
Kashif Ali
Re: ORA-23401 materialized view "string"."string" does not exist [message #322983 is a reply to message #322977] Tue, 27 May 2008 00:15 Go to previous message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No!

"sys." suggests that "snap$" is owned by SYS, i.e. it is a data dictionary view. It displays information stored in one or more underlying tables, also owned by SYS. Never ever mess up with data dictionary, or you might make Oracle database stop responding.

Materialized view is in snap$ view if it exists. As "all_mviews" selects information from "dba_mviews" and "dba_mviews" from "snap$", I'd say that you are referencing a materialized view that, simply, does not exist.

As owner of the 'apps' schema (or, at least, you have access to it), query "user_mviews" and see whether it exists in your schema. If not, ask DBA to check it in "all_mviews". If it still doesn't exist, well, perhaps you have misspelled its name, someone has dropped or ... hm, something similar.
Previous Topic: Strange Error When Connecting Form 6i
Next Topic: error FRM - 41039 Invalid Alert ID
Goto Forum:
  


Current Time: Tue Dec 06 10:25:35 CST 2016

Total time taken to generate the page: 0.07565 seconds