Forum Stats

  • 3,824,944 Users
  • 2,260,442 Discussions
  • 7,896,356 Comments

Discussions

Datapump Logfile - Ignore error list

Aish13
Aish13 Member Posts: 203 Bronze Badge
edited Jul 19, 2020 3:33PM in Database Ideas - Ideas

It would be great to have a Ignore_error_list parameter to allow the invoker to omit certain expected errors from the logfile.

Most of the times when copying a table from one environment to another, the grants fail due to a differnece in roles and users.

But we would not want to exclude the grants, as we want them to be granted to the existing users/roles. Although such errors are ignorable, but they usually fill up the logfile, making it difficult to filter out the actual errors, without the use of OS commands.

So it would be extremely useful to have an ignore list in place where we can explicit  suppress such expected errors .

Or a method that helps filter the errors via the datapump API's

Thanks,

Aishwarya

ctriebPKRuser3884308BartCern
5 votes

Active · Last Updated

Comments

  • User51642 Yong Huang
    User51642 Yong Huang Member Posts: 164 Bronze Badge
    edited Jul 28, 2020 4:36PM

    We do data pump a lot and feel the pain as you! But I don't think an ignore error list is a good idea. Just do a thorough check before the work (check dba_X_privs where X is sys, role, tab, in both source and target DBs). Once the data pump is finished, you can quickly check errors this way:

    $ grep ^ORA- mydatapump.log | sort | uniq -c | sort -n
    ...
        83 ORA-01917: user or role 'MELROLE_CLINMOD_SURGICAL' does not exist
        140 ORA-01917: user or role 'DM_ANALYST' does not exist
        154 ORA-01917: user or role 'MELROLE_TISSUE_BANK_ADMIN' does not exist
        832 ORA-39083: Object type OBJECT_GRANT failed to create with error:

    It's easier to read this way.

    Sven W.
  • Sven W.
    Sven W. Member Posts: 10,535 Gold Crown

    Datapump import (impdp) already has an exclude option. For example you can set it to exclude all grants. I didn't test it, but it seems you could also use it to exclude specific grants.

    EXCLUDE=GRANT