DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: materialized view problem

  1. #1
    Join Date
    Apr 2002
    Posts
    135
    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

  2. #2
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Hi Sona,
    try creating public synonym for this MV and repeat the process again.
    All The Best
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  3. #3
    Join Date
    Apr 2002
    Posts
    135
    my problem is in Refreshing.
    I think that will not help.
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width