Database Administration (MOSC)

MOSC Banner

snapshot too old when logical backup happen in the background

edited Jan 27, 2014 4:39PM in Database Administration (MOSC) 3 commentsAnswered
hi all,need to understand exactly how does the data pump works.
I got this error sometime, think is when the logical export is running, there is some kind of batch job running at the same time on this table FGHN_DETACH and crashes with the export job.
i was thinking why oracle will choose to skip it?
Can i assume that there is some kind of DML happening in the background as there is a ora-01555 error. Meaning something is updating on this table and while the export utility is 'reading' it, plus the undo is also phase out, thus both error appear?

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