datapump anomaly, grants, any ideas

suport SR 6469074.993

Oracle 10.2.0.3 on Sun Solaris.

Import via impdp works, but doesnt import statistics. impdp generates error when importing statistics. Conventional exp/imp works fine, and does import statistics.

Support claims that to successfully import statistics via impdp, you need to either runs as SYS, run with sys-priv, or grant INS/DEL on sys.impdp_stats to the importing user.

Manuals state that exp_full_database and imp_full_database are all that is needed to successfully use datapump. Support now disagrees.

We do not want to manually grant-out two specific grants in our 150+ databases, but we like to use dp to avoid plethora of files everywhere.

Questions

• Anyone had this problem ?
• Anyone find this strange ?
• Anyone have cheapo workaround ?

Regards,
PdV
(miffed off by Metalink)

This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.

--
http://www.freelists.org/webpage/oracle-l