Re: DBMS_DATAPUMP API equivalent of EXCLUDE=grants

On 2015-02-20, mistercaste_at_gmail.com <mistercaste_at_gmail.com> wrote:
> On Tuesday, April 8, 2008 at 3:09:30 PM UTC+1, bcla..._at_gmail.com wrote:
>> I'm trying to do some importing in PL/SQL instead of using the command
>> line impdp utility. The thing is, that the impdp utility takes
>> EXCLUDE=grant whereas there seems to be no direct mapping of this
>> functionality to to the DBMS_DATAPUMP api.
8>< -------
>> Thanks.
>
> Hi
>
> You can achieve this with the following command:
> DBMS_DATAPUMP.METADATA_FILTER(h1, 'EXCLUDE_PATH_LIST', 'SYSTEM_GRANT');
>
> Reference:
> https://community.oracle.com/thread/839324
>
> Good work!

Good work answering a mesaage from 2008, I suspect they have either firured it out or given up a long time ago.

Eric

-- 
ms fnd in a lbry