Expdp fails with ORA-31693 ORA-02354 ORA-01555
Hi!11.2.0.2
Im trying to take a consistent export of a schema. I use
flashback_time='to_timestamp(sysdate)'
in my parameter file but the export hits errors:
Processing object type SCHEMA_EXPORT/USER
. . exported "STAFFPLANADM"."BATCHTASK_PERSON" 5.468 KB 0 rows
ORA-31693: Table data object "STAFFPLANADM"."STRINGBLOB" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSSMU2_4026738760$" too small
ORA-31693: Table data object "STAFFPLANADM"."BATCHLOAD" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSSMU2_4026738760$" too small
Im trying to take a consistent export of a schema. I use
flashback_time='to_timestamp(sysdate)'
in my parameter file but the export hits errors:
Processing object type SCHEMA_EXPORT/USER
. . exported "STAFFPLANADM"."BATCHTASK_PERSON" 5.468 KB 0 rows
ORA-31693: Table data object "STAFFPLANADM"."STRINGBLOB" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSSMU2_4026738760$" too small
ORA-31693: Table data object "STAFFPLANADM"."BATCHLOAD" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSSMU2_4026738760$" too small
0