90 Dakika – 90 Türkiye

Database Code Eror rss

ORA-30372(0)

08 Şubat 2010

ORA-30372: fine grain access policy conflicts with materialized view
Cause: A fine grain access control procedure has applied a non-null policy to the query for the materialized view.
Action: In order for the materialized view to work correctly, any fine grain access control procedure in effect for the query must return a null policy when the materialized view is being created or refreshed. This may be done by ensuring that the usernames for the creator, owner, and invoker of refresh procedures for the materialized view all receive a null policy by the …

ORA-30372

ORA-30377

ORA-30377: table string.MV_CAPABILITIES_TABLE not found
Cause: You have used the DBMS_MVIEW.EXPLAIN_MVIEW() API before you have defined the MV_CAPABILITIES_TABLE.
Action: Invoke the admin/utlxmv.sql script after connecting to the desired schema.

ORA-30384

ORA-30384: specified column name does not exist in the attribute
Cause: A column was encountered that is not defined within the attribute.
Action: Check the attribute column name spelling.

ORA-30394

ORA-30394: source statement identical to the destination statement
Cause: The source statement was identical to the destination statement
Action: Make sure both source and destination statements are not identical


More in this category: