ORA-0131: insufficient privileges during expdp
From dbawiki
Revision as of 08:58, 5 December 2011 by 10.250.159.106 (talk) (Created page with "'''Problem''' During a full export using expdp, one table in one schema gives permissions errors: ORA-31693: Table data object "TOEPRO"."PROJECT" failed to load/unload and is be...")
Problem During a full export using expdp, one table in one schema gives permissions errors:
ORA-31693: Table data object "TOEPRO"."PROJECT" failed to load/unload and is being skipped due to error: ORA-01031: insufficient privileges
Research Not many people seem to have the same problem and I suspect it is because most people would use the system user to expdp their databases. There was one result that seemed to match [1]
Solution Connect to affected database as sys and:
grant FLASHBACK ANY TABLE to impexpusr;