DIA-28092：The parameter string with value 'string' has an error.
错误码
错误描述：The parameter string with value 'string' has an error.
错误原因：The value of the parameter had an error. If DBMS_REDACT.CREATE_POLICY_EXPRESSION was invoked and the POLICY_EXPRESSION_NAME parameter had an error, the policy expression name either already existed, or was invalid. If DBMS_REDACT.DROP_POLICY_EXPRESSION was invoked and the POLICY_EXPRESSION_NAME parameter had an error, the policy expression either did not exist, was still in use (was applied to a column), or was invalid. If DBMS_REDACT.APPLY_POLICY_EXPR_TO_COL was invoked and the POLICY_EXPRESSION_NAME parameter had an error, a policy expression may already exist on this column. Only one policy expression may be associated with any given column. The name of any Oracle Data Redaction policy expression associated with a given column can be found in the REDACTION_EXPRESSIONS catalog view. If the DBMS_REDACT.ADD_POLICY was invoked and the OBJECT_SCHEMA parameter referenced the APEX, Sharding (GSMADMIN_INTERNAL) or Spatial installation schema, the operation was prevented. Data redaction policies are not supported on objects within the APEX, Sharding (GSMADMIN_INTERNAL) or Spatial installation schema. If the DBMS_REDACT.ADD_POLICY was invoked and the OBJECT_NAME references a metadata-linked view, the operation was prevented. Data redaction policies are not supported on metadata-linked views. If the DBMS_REDACT.ADD_POLICY was invoked and the OBJECT_NAME references an OLAP analytic workspace table, the operation was prevented. Data redaction policies are not supported on OLAP analytic workspaces.
解决方法：Provide a valid value for the parameter. If DBMS_REDACT.CREATE_POLICY_EXPRESSION was invoked and the parameter was POLICY_EXPRESSION_NAME, provide a valid (new or existing) policy expression name. The names of all existing Oracle Data Redaction policy expressions can be found in the REDACTION_EXPRESSIONS catalog view. For the POLICY_EXPRESSION_NAME parameter of the DBMS_REDACT.DROP_POLICY_EXPRESSION procedure, provide a valid existing policy expression name which is not currently in use (applied to any column). The names of the columns to which a given policy expression is currently applied can be found in the REDACTION_EXPRESSIONS catalog view. For the POLICY_EXPRESSION_NAME parameter of the DBMS_REDACT.APPLY_POLICY_EXPR_TO_COL procedure, either provide NULL to remove the current policy expression association of the column, or provide a valid existing policy expression name. There is currently no API to alter an existing association. For now it must first be dropped followed by applying the new association. The names of all existing policy expressions can be found in the REDACTION_EXPRESSIONS catalog view. If DBMS_REDACT.ADD_POLICY was invoked, provide an OBJECT_SCHEMA which is not the APEX or Spatial installation schema. Data redaction policies are not supported on objects within the APEX or Spatial installation schema. If DBMS_REDACT.ADD_POLICY was invoked, provide an OBJECT_NAME that does not reference a metadata-linked view. If DBMS_REDACT_ADD_POLICY was invoked, provide an OBJECT_NAME that does not reference an OLAP analytic workspace table.
向认证技术专家提问
向技术专家提问
