Re: DBMS_DATAPUMP API equivalent of EXCLUDE=grants

From: <>
Date: Fri, 20 Feb 2015 05:23:21 -0800 (PST)
Message-ID: <>

> 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.
> I think such filtering is done via DBMS_DATAPUMP.metadata_filter.
> Various filters are available including one called EXCLUDE_PATH_EXPR.
> There are object paths that can be viewed by selecting from
> However I don't know which of these correspond to those that would be
> excluded if using EXCLUDE=grant with impdp.
> I also have not been able to find this out on the web.
> Does anyone know exactly what impdp's EXCLUDE=grants does in terms of
> the DBMS_DATAPUMP api?
> Thanks.


You can achieve this with the following command: DBMS_DATAPUMP.METADATA_FILTER(h1, 'EXCLUDE_PATH_LIST', 'SYSTEM_GRANT');


Good work! Received on Fri Feb 20 2015 - 14:23:21 CET

Original text of this message