Hi All,
I am trying to do partition exchange of a partitioned table and a temporary table.
The partitioned table has VPD policies on it to implement fine gained access control.
ALTER TABLE PartitonTab1
EXCHANGE PARTITION tab1_partition1
WITH TABLE tmpTab1
WITHOUT VALIDATION
UPDATE GLOBAL INDEXES;
I am getting below error:
ORA-14136: ALTER TABLE EXCHANGE restricted by fine-grained security
To eliminate the error , either we have to remove VPD Policies on table , PartitonTab1 OR
GRANT 'EXEMPT ACCESS POLICY ' to the owner.
In my case both these options are not possible as this would be a Security Breach.
Even though I may have to remove temporarily VPD policies on table ,, for the duration of the 'PARTITION EXCHANGE' operation ,
this would be security issue , as every one can access the data for that period...
Can any one please suggest some alternative ......