Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Disable a Policy in a Table

775371Jun 18 2012 — edited Jun 19 2012
Hi All,

I am new to DBA. I am facing one issue as one policy is enabled on a table. I just want to disable the policy on that table.

Kindly help me on
1. What is the steps to disable a policy from a table.
I saw some docs which explain the steps like [SA_ADMIN_POLICY.DISABLE_TABLE_POLICY(xxx,xxxxx,xxxx)], but when I run,getting erro "identifier 'SA_POLICY_ADMIN.DISABLE_TABLE_POLICY' must be declared". I don't how to run and from where.

policy name -> policy1
schema -> app
table -> purchase


Kindly help to solve this issue.


Thanks,
Asim.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2012
Added on Jun 18 2012
4 comments
4,432 views