| ORA-23401 materialized view "string"."string" does not exist [message #322966] |
Mon, 26 May 2008 23:45  |
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 #322983 is a reply to message #322977] |
Tue, 27 May 2008 00:15  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
