We help IT Professionals succeed at work.

HOw to remove a policy function from a table

dodgerfan
dodgerfan asked
on
7,673 Views
Last Modified: 2013-12-19
I've imported a database into Oracle 10g. How do I remove policy functions from tables? When I try to display data from some tables I get the ORA-28100: policy function schema LBACSYS is invalid. Any thoughts?
Comment
Watch Question

Database Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Naveen KumarProduction Manager / Application Support Manager
CERTIFIED EXPERT

Commented:
If you can query dba_ views, then use that instead of all_policies

SELECT *
  FROM dba_policies
 WHERE object_owner = 'YOUR_SCHEMA' AND object_name = 'YOUR_TABLE'
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.