hai
I have a user .He is granted sysdba rights.
i connected to sqlplus as the user and created materialized view using a script.the view got created.But when i tried to refresh on demand using dbms_snapshot.refresh(8i) it is not getting refreshed.
then i tried this
i connected as internal/oracle in sqlplus and created the Mview in the user's schema and then again connected as the user in sqlplus and gave the refresh command,
the MView gets refreshed.
I do know what's the problem.
Is it needed the creation of Mview should be done as internal or the user with sysdba.But my user has sysdba rights also.
But when i create MView in OEM with preferred credentials as the user it is working properly.
but not when creating in sqlplus
any idea please
Good Judgement comes from Experience.
Experience comes from Bad Judgement