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

Troubleshooting the “Cannot Generate SSPI Context” Error After SQL Server Migration

  Introduction After a recent  SQL Server migration from 2012 to 2022 , our team encountered a classic authentication issue: The target prin...