datapump hidden parameter

Discovered a hidden (pretty pointless) parameter today.

silent=banner

This hides the version information fro the logfile - not sure what practical use this really has other than saving a few bytes but it's there....


As you can see in the second run the banner has now magically gone....

Comments

  1. Seems that there are same options as in SQL*Loader. You can use silent=all and do not get any output on the console. Useful if you spawning several EXPDP sessions in the background.
    oracle@dbsrv1p6:/home/oracle $ expdp testuser directory=data_pump_dir dumpfile=testuser.dmp silent=all
    Password:
    oracle@dbsrv1p6:/home/oracle $

    ReplyDelete
  2. If silent=all you will still get output in the log file (sans the banner).
    Bad news is that in silent mode (both "all" and "banner") Data Pump will not calculate elapsed time. Looks like the timer is initialized by the banner code. So if you prefer to have elapsed time in the log, redirecting to /dev/null can be a better choice than this undocumented parameter.

    ReplyDelete

Post a Comment