Refresh materialized view by other user then owner 2006-04-30 - By varciasz
I'm using SQL *Plus Worksheet and logging into Database thru logging window
after running "C:\oracle\ora92\bin\oemapp.bat worksheet" as SYSBDA
(username: SYSTEM)
In first mail I send whole code of creating "USER2", Table, Materialized
View and refreshing it command used by "USER2"
The only output shown by SQL *Plus Worksheet is an error that also entirely
I put to this mail, unless you mean any other output then please clarify
this
SYSTEM has granted roles: DBA, AQ_ADMINISTRATION_ROLE
__ __
From: Stefan Knecht [mailto:knecht.stefan@(protected)]
Sent: Monday, May 01, 2006 2:01 AM
To: varciasz
Cc: oracle-l@(protected)
Subject: Re: Refresh materialized view by other user then owner
What client are you using to connect to the database ? How exactly are you
connecting to "SYSTEM" ? Do you have SYSDBA granted to SYSTEM and connect
SYSTEM AS SYSDBA ?
If possible, can you post the complete output of what you're trying to
execute ?
Stefan
On 5/1/06, varciasz <varciasz@(protected)> wrote:
Thanks for trying but this still doesn't work at all.
>>You're creating the materialized view in schema SYSTEM, but try to refresh
>>an mview in schema SYS - that cannot work.
At first - all tables, MViews etc when I'm logged in as "SYSTEM" appears in
SYS schema. That's why I used "SYS." instead "SYSTEM." I don't know how its
work but it is like that.
So after :
EXEC dbms_mview.refresh('SYSTEM.V1 ');
I have error from Oracle:
*
ERROR at line 1:
ORA-23401 (See ORA-23401.ora-code.com): materialized view "SYSTEM"."V1" does not exist
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_SNAPSHOT", line 794
ORA-06512 (See ORA-06512.ora-code.com): at " SYS.DBMS_SNAPSHOT", line 851
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_SNAPSHOT", line 832
ORA-06512 (See ORA-06512.ora-code.com): at line 1
And after
EXEC dbms_mview.refresh('sys.V1 ');
I have the same old error:
*
ERROR at line 1:
ORA-01031 (See ORA-01031.ora-code.com): insufficient privileges
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_SNAPSHOT", line 794
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_SNAPSHOT", line 851
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_SNAPSHOT", line 832
ORA-06512 (See ORA-06512.ora-code.com): at line 1
It looks like that this is not so simple ...
__ ____ ____ ____ ____ ____ ____ ____ __
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]
On Behalf Of Stefan Knecht
Sent: Sunday, April 30, 2006 11:00 PM
To: oracle-l@(protected)
Subject: Re: Refresh materialized view by other user then owner
|
|
