EXP-00079 when exporting VPD schema in oracle


. . exporting table CELLONE_DUP_CUSTOMER 430122 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00079: Data in table "CELLONE_HEADERS" is protected. Conventional path may only be exporting partial table.

Solution
---
1) grant sysdba to the user and try to export

if you are exporting with a user called SCOTT then
GRANT SYSDBA TO SCOTT;

Then try to take export.

 

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post