Database Administration (MOSC)

MOSC Banner

Getting ora-01555 on expdp

edited Aug 15, 2017 3:00PM in Database Administration (MOSC) 9 commentsAnswered ✓

While performing a full export I'm getting the below error:

ORA-31693: Table data object "SYSTEM"."SCHEDULER_PROGRAM_ARGS" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout

ORA-01555: snapshot too old: rollback segment number 23 with name "_SYSSMU23_1332513299$" too small

I have increased undo_retention to 4 hours and the UNDO tablespace can extend up to 96GB.

But the error keeps coming.

Strange message:

Table data object "SYSTEM"."SCHEDULER_PROGRAM_ARGS" failed to load/unload

"SYSTEM"."SCHEDULER_PROGRAM_ARGS" is a view and returns only 12 rows.

Any idea? DB version is 12.1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center