Database Utilities (MOSC)

MOSC Banner

Error handling for data pump script

edited Jul 14, 2020 8:40AM in Database Utilities (MOSC) 10 commentsAnswered ✓

Hi All -

We now have a working script for our data pump job (thanks to some contributions here ).

I have been asked if it would be possible to have some kind of error handling in the script.

Ultimately, there isn't much going on inside the script besides setting a few environment variables and running impdp with a parfile and a log file.

Are there any best practices with data pump for something like this? Could we just do a RETCODE="$?" after the impdp command? Then, a return $RETCODE at the very end?

DB version 12.2.0.1

Regards,

Charles

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