"Oracle Dictionary: Access to DBA views..." message received refreshing Materialized view (4282470)

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

"Oracle Dictionary: Access to DBA views..." message received refreshing Materialized view
Descripción

When trying to refresh a materialized view, the following message is received.

"Oracle Dictionary: Access to DBA Views is required to view Rollback Segment data"
Causa

Lack of privilege.
Resolución

In order to refresh materialized view, this package, DBMS_MVIEW, is being invoked.

DBMS_MVIEW.REFRESH-Refreshes one or more materialized views
DBMS_MVIEW.REFRESH_ALL_MVIEWS-Refreshes all materialized views
DBMS_MVIEW.REFRESH_DEPENDENT-Refreshes all table-based

Make sure the user has privileges to this.

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Producto(s):: SQL Navigator for Oracle
6.2.1, 6.2, 6.1.0.1094, 6.0.0.1055, 5.5.4.847, 5.5.3.791, 5.5.2.742, 5.5.1.737, 5.5.0.713, 5.1.0.655, 5.0.0.607, 4.5.1.538, 4.5.1, 4.5.0.534, 4.4.1.501, 4.4.0.500, 4.3.2.476, 4.4, 4.3.2, 4.3.1, 4.3, 4.2, 4.1.2, 4.1c1, 4.0c3, 4.0c2, 4.0c1, 3.2d11, 3.2, 2.0x

Historial del artículo:: Creado el: 1/29/2010
Última actualización: 5/7/2023

Título