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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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;