OraFAQ Forum: SQL & PL/SQL » Materialized view Refresh

Home » SQL & PL/SQL » SQL & PL/SQL » Materialized view Refresh

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Materialized view Refresh [message #513936]

Thu, 30 June 2011 06:25

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?

Report message to a moderator

Re: Materialized view Refresh [message #513942 is a reply to message #513936]

Thu, 30 June 2011 06:43

Michel Cadot
Messages: 54247
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

Report message to a moderator

Re: Materialized view Refresh [message #575464 is a reply to message #513942]

Wed, 23 January 2013 08:16

sss111ind
Messages: 272
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

Report message to a moderator

Re: Materialized view Refresh [message #575466 is a reply to message #575464]

Wed, 23 January 2013 08:17

Michel Cadot
Messages: 54247
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Scan the alert.log file.

Regards
Michel

Report message to a moderator

Re: Materialized view Refresh [message #575468 is a reply to message #575466]

Wed, 23 January 2013 08:21

sss111ind
Messages: 272
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

Report message to a moderator

Re: Materialized view Refresh [message #575469 is a reply to message #575468]

Wed, 23 January 2013 08:21

Michel Cadot
Messages: 54247
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

Report message to a moderator

Re: Materialized view Refresh [message #575471 is a reply to message #575469]

Wed, 23 January 2013 08:27

sss111ind
Messages: 272
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

Michel Cadot
Messages: 54247
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

Report message to a moderator

Previous Topic:	PL/SQL Anonymous block
Next Topic:	External table query (compare number records in file with external table)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 16:14:42 CDT 2013

Total time taken to generate the page: 0.34940 seconds