Re: DBMS_DATAPUMP API equivalent of EXCLUDE=grants

> 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
> DATABASE_EXPORT_OBJECTS, SCHEMA_EXPORT_OBJECTS and
> TABLE_EXPORT_OBJECTS.
>
>
> 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.

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! Received on Fri Feb 20 2015 - 14:23:21 CET