Materialized View

[altieri.andrade]

What are the necessary grants that I must apply to a new user so that it is allowed to make the refresh of materialized views.

Note: Can not be DBA Grant.

[dr_gori]

See this link with the Grants: http://www.psoug.org/reference/system_privs.html
TRIES A ALTER ANY MATERIZED VIEW

[HenriqueMachado]

How does a materialized views work ???

[dr_gori]

A common view is just a SQL stored on the bench. The common view does not occupy physical space, it is only used to facilitate some consultation, etc.

Already materialized view is also a SQL stored in the bank, but Oracle generates a physical table for her. That is, when you do select in this view, you are making a select on a table yourself! (This is very useful when you need to access information from multiple tables quickly because all information is already saved in this materialized view).

There are a number of restrictions on use. It is usually more used in BI environment that suffer low update, etc.

[muttley]

Where can I find English / Portuguese materials on the subject



I am grateful: Oops: [/quote]