Ora-01031: Insufficient Privileges, When Using The Flashback_time Option with EXPDP/IMPDP Network_link
(Doc ID 436106.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
When running datapump expdp/impdp via remote connection (network_link or tns string) or locally as another user other than SYS/SYSTEM to export/import another schemas data from the source (export) instance, the process fails with following errors if the FLASHBACK_TIME or FLASHBACK_SCN is used to get a consistent export/import.
ORA-31693: Table data object "SCOTT"."FLSHBK_EMP" failed to load/unload and is being skipped due to error:
ORA-01031: insufficient privileges
ORA-02063: preceding line from FLASH_BK_EXPDP
The network_link references a valid dblink which is configured to connect to remote (export) instance as a non SYS/SYSTEM schema that has been granted EXP_FULL_DATABASE.
When you connect to export instance as this same user via sqlplus you can query the export table but can not query it using flashback query
SQL> connect <non SYS/SYSTEM user>/<password>
SQL> select count(*) from scott.emp;
COUNT(*)
----------
14
SQL> select count(*) from scott.emp as of timestamp(sysdate);
select count(*) from scott.emp as of timestamp(sysdate)
*
ERROR at line 1:
ORA-01031: insufficient privileges
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |