Tuesday, July 8, 2025

Fix for ORA-01031 TTS EXPDP with database vault

Grant the below permission to system user 

1. EXP_FULL_DATABASE

2. IMP_FULL_DATABASE

3. exec dvsys.dbms_macadm.authorize_datapump_user('SYSTEM');

4. grant dv_owner to system.


This should handle the full=y and transportable=always scenraio in expdp just fine.

It is tested in 19.27.

No comments:

Post a Comment

OKV platform certificate rotation - pitfall , awareness!!!!

OKV version: 21.9 Setup: Multimaster R/W cluster Plan: https://docs.google.com/spreadsheets/d/e/2PACX-1vSaXXTjj9cE1fvYpNmsDNBOkTIw78yTwQ6a9o...