PL/SQL (MOSC)

MOSC Banner

How to make DATAPUMP API history

edited Mar 18, 2019 3:42AM in PL/SQL (MOSC) 5 comments

I'm doing backup DATAPUMP every day.

I want to know how to make datapump status history.

so I'm considering datapump API.

I know doing backup by datapump api. but I don't know how to make pumpt status history.

I want to make datapump result table or show the result in alert.log.

How can I do that?

I'm refering to blog (https://ilmarkerm.eu/blog/2013/04/sample-code-using-datapump-api-for-metadata-and-data-filtering/

I was looking for PL/SQL examples to use metadata and data filtering in datapump API, but I didn’t find any. So here is one example. It uses table reload_dev_tables to specify what schemas/tables should be exported using data pump and what where clause should be set.

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