Sunday, April 14, 2013

ORA-31693: Table data object failed to load/unload and ORA-01031: insufficient privileges when using expdp

ORA-31693 and ORA-01031 could be seen when exporting the full schema with flashback_time clause.
ORA-31693: Table data object "SCHEMA"."Table_name" failed to load/unload and is being skipped due to error:
ORA-01031: insufficient privileges
Database version is 11.1.0.7. The error only appears intermittently and only for some tables. Metalink note 13715680.8 says the issue is also confirmed on 11.2.0.2 and 11.2.0.3
This is caused by user doing the export not having the flash back privileges. Granting flashback any table privilege to the user doing the export resolves the issue (confirmed on 11.1.0.7).




Useful metalink notes
Getting ORA-39127 ORA-1031 Error With DataPump Export (EXPDP) [ID 414996.1]
Bug 13715680 - Import fails with ORA-1031 for some TIMESTAMP data [ID 13715680.8]
Ora-01031: Insufficient Privileges, When Using The Flashback_time Option with EXPDP/IMPDP Network_link [ID 436106.1]

Related Post
Using flashback time with expdp