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

MSSQL: Backup/Restore logically a large table

  MSSQL : Backup/Restore logically a large table Objective: We perform 3 data processing steps in this tutorial 1.Download an opensource dat...