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 SSH Issues in Vagrant (Oracle Linux 9)

  Troubleshooting SSH Issues in Vagrant (Oracle Linux 9) This guide outlines the steps to resolve SSH authentication errors, such as "N...