Home » SQL & PL/SQL » SQL & PL/SQL » Materialized view Refresh
Materialized view Refresh [message #513936] Thu, 30 June 2011 06:25 Go to next message
swapnalinagle
Messages: 1
Registered: June 2011
Junior Member
how to Refresh materialized view by other user than owner.
One option is there to give drop any view/table grant to other user. But can't do this as it's a system privileges.

Is there any option to refresh a view without dropping the structure?
Re: Materialized view Refresh [message #513942 is a reply to message #513936] Thu, 30 June 2011 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Using dbms_snapshot or alter materialized view, but of course you must have the appropriate privilege.

Regards
Michel


Re: Materialized view Refresh [message #575464 is a reply to message #513942] Wed, 23 January 2013 08:16 Go to previous messageGo to next message
sss111ind
Messages: 508
Registered: April 2012
Location: India
Senior Member

Hi All,

I have a materialized view suppose emp_mv.And I scheduled with dbms_job to run everyday 12 A.M..And I want to capture the inforamtion when materialized view refresh fails. How can I do that.

Regards,
Nathan
Re: Materialized view Refresh [message #575466 is a reply to message #575464] Wed, 23 January 2013 08:17 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Scan the alert.log file.

Regards
Michel
Re: Materialized view Refresh [message #575468 is a reply to message #575466] Wed, 23 January 2013 08:21 Go to previous messageGo to next message
sss111ind
Messages: 508
Registered: April 2012
Location: India
Senior Member

Hi Michel,

Thanks for fastest response.I donot have dba privilege and I want to do with programming(take inserting into some table).
After that whether I have to rerun this job. But that also I cant do because the job is fixed to run on everyday 12 A.M.

What suppose to do I am.Any suggestion Please..

Regards,
Nathan

Re: Materialized view Refresh [message #575469 is a reply to message #575468] Wed, 23 January 2013 08:21 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can create or ask your DBA to create an external table on alert.log file and use SQL to scan it.

Regards
Michel
Re: Materialized view Refresh [message #575471 is a reply to message #575469] Wed, 23 January 2013 08:27 Go to previous messageGo to next message
sss111ind
Messages: 508
Registered: April 2012
Location: India
Senior Member

Thanks again Michel,

So in the alert error (why it got failed) was captured ,Right.And DBA has to take the decision further.
http://www.adp-gmbh.ch/ora/admin/read_alert/index.html

Regards,
Nathan

[Updated on: Wed, 23 January 2013 08:36]

Report message to a moderator

Re: Materialized view Refresh [message #575472 is a reply to message #575471] Wed, 23 January 2013 08:49 Go to previous message
Michel Cadot
Messages: 60018
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
And DBA has to take the decision further.


DBA or you or both.

Thanks for the link.
Michel
Previous Topic: PL/SQL Anonymous block
Next Topic: External table query (compare number records in file with external table)
Goto Forum:
  


Current Time: Mon Dec 22 15:29:26 CST 2014

Total time taken to generate the page: 0.14788 seconds