Skip to Main Content
  • Questions

  • DBMS_DATAPUMP suppress ORA-39181 errors

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Nigel.

Asked: September 29, 2015 - 8:24 pm UTC

Last updated: September 30, 2015 - 12:49 am UTC

Version: 11.2.0.3.0

Viewed 1000+ times

You Asked

Hi,

Is there any way to suppress the "ORA-39181: Only partial table data may be exported due to fine grain access control.." error message from the log file of a DBMS_DATAPUMP export, without

*) disabling the policies, or
*) issuing the "grant exempt access..." privilege?

We have Row Level Security on the tables being exported to restrict records based on the user's access - the idea being that the data we want to export is always the filtered results for that user anyway. It's a shame that the log file (which we'd like to keep) is full of errors - even though it's a perfectly valid export.

Thanks in advance, and nice to see this site active again.

N

and Connor said...

I checked with some people and "This is expected behaviour" was the response, so sorry, you're stuck with that message.

All I can suggest that (if you're keeping the log files as an audit trail) is perhaps grep out that particular message before saving it way.

I havent tried the old 'exp' trick of writing log files to a named pipe, so this could be done 'on the fly' - you could explore that.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, October 02, 2015 - 3:52 pm UTC

Good grief - 20 years working with Unix and I'd not even heard of named pipes.
Thanks for the pointers and the speedy response.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.