Home » RDBMS Server » Server Utilities » Oracle 12c expdp using external table when it should be using direct (Oracle Database Enterprise Edition v12.2.0.1.0 / Linux 3.8.13-16.2.1.el6uek.x86_64)
Oracle 12c expdp using external table when it should be using direct [message #679756] Mon, 23 March 2020 11:33 Go to next message
markhooper99
Messages: 19
Registered: October 2013
Location: Calgary
Junior Member
We're trying to figure out how to get expdp convinced to use 'direct' rather than 'external table' mode when exporting rows from a table that is set with an RLS (Row Level Security) 'select' policy.

We were led to believe that if we granted EXEMPT ACCESS POLICY to the Oracle user doing the export data pump that 'direct' mode would be used, but it doesn't.

The table in question has approximately 125 million rows so the difference in export data pump times between 'direct' and 'external table' is quite substantial - 2 to 3 minutes in 'direct' mode, 10 hours in 'external table' mode.

Does anyone have any thoughts on this ?
Re: Oracle 12c expdp using external table when it should be using direct [message #679757 is a reply to message #679756] Mon, 23 March 2020 12:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Still waiting for your feedback in your previous topic(s)...

Re: Oracle 12c expdp using external table when it should be using direct [message #679758 is a reply to message #679757] Mon, 23 March 2020 17:14 Go to previous messageGo to next message
markhooper99
Messages: 19
Registered: October 2013
Location: Calgary
Junior Member
Acknowledged Michel but I looked through threads I initiated and can't find one that is waiting for my feedback.
If you can tell me which one I'd be more than happy to chime in on it, thanks.
Re: Oracle 12c expdp using external table when it should be using direct [message #679761 is a reply to message #679758] Tue, 24 March 2020 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

For instance your last one: your question, 2 answers, no feedback.

Re: Oracle 12c expdp using external table when it should be using direct [message #679765 is a reply to message #679761] Tue, 24 March 2020 08:57 Go to previous messageGo to next message
markhooper99
Messages: 19
Registered: October 2013
Location: Calgary
Junior Member
The responses in that thread provided obvious answers to the question that I posed.
Other than 'acknowledged' I'm not sure what feedback you are looking for.
Re: Oracle 12c expdp using external table when it should be using direct [message #679768 is a reply to message #679765] Tue, 24 March 2020 11:33 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

There were not so obvious for us from what you posted otherwise we didn't post them.
And then, yes, acknowledge would be fair and thank to the time spent at least to read your question and make answers.

Now from what you say, I'll think my answer will just be obvious and won't be worth seeing so I will prevent from wasting my time posting them.


Previous Topic: Parfile expdp problem
Next Topic: ORA-12899 Error
Goto Forum:
  


Current Time: Thu Mar 28 16:58:41 CDT 2024