This content has been marked as final. Show 2 replies
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';
- 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.