10.250.159.106: 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..."

2011-12-05T08:58:36Z

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..."

New page

'''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 [http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=41103|here]

'''Solution'''
Connect to affected database as sys and:
grant FLASHBACK ANY TABLE to impexpusr;

ORA-0131: insufficient privileges during expdp - Revision history

10.250.159.106: 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..."