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

サポートと今すぐチャット

戻る

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

タイトル

"Oracle Dictionary: Access to DBA views..." message received refreshing Materialized view
説明

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"
原因

Lack of privilege.
対策

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.

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

推奨コンテンツ

製品：: 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

タイトル