This discussion is archived
2 Replies Latest reply: Jul 31, 2012 5:10 AM by slavonagy RSS

ORA-14136: ALTER TABLE EXCHANGE (FGAC/VPN)

user359757 Newbie
Currently Being Moderated
I am getting this error when I am trying to do a partition exchange however the user id that is doing the exchange has been granted "expemt access policy" and the policy itself has been disabled. I can stop the error by dropping the policy but that is not a useful solution. Why am I getting this error and how do I fix it?

Any help would be appreciated.

Thanks,
Tom
  • 1. Re: ORA-14136: ALTER TABLE EXCHANGE (FGAC/VPN)
    damorgan Oracle ACE Director
    Currently Being Moderated
    1. What Oracle version?
    SELECT * FROM v$version;
    2. Post the DDL for the partition exchange (be sure to use formatting tags to make your listing readable ... look in the FAQ for how).
    3. Should VPN really be VPD? If not explain what a VPN has to do with this.
  • 2. Re: ORA-14136: ALTER TABLE EXCHANGE (FGAC/VPN)
    slavonagy Newbie
    Currently Being Moderated
    I guess you have an active RLS-security on your table:

    SELECT * FROM dba_policies WHERE object_owner='&your_schema' AND object_name='&your_table_name';

    If so,
    - drop the policy (DBMS_RLS.DROP_POLICY),
    - do the exchange partition and
    - re-create the policy again (DBMS_RLS.ADD_POLICY)

    Another option with GRANT EXEMPT POLICY to your schema is probably too much. But maybe a possibility if you are the only schema in the database and have the DBA privileges.

    Ciao,
    Slavo

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points