Thursday, April 16, 2015

DATA Vault expdp error

Even using system  because of DB vault i am getting some insufficient priveleges error.

So when you have db vault installed

Run the following statement as Database vault owner and you are good to go

EXEC DVSYS.DBMS_MACADM.AUTHORIZE_DATAPUMP_USER('XXX');


here replace xxx with username you are trying to export with

No comments:

Post a Comment

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...