Re: DBMS_DATAPUMP API equivalent of EXCLUDE=grants
Date: Fri, 20 Feb 2015 05:23:21 -0800 (PST)
Message-ID: <9e7a5c7e-8d48-4b23-bd30-cfad0ef8c688_at_googlegroups.com>
> 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:
Good work!
Received on Fri Feb 20 2015 - 14:23:21 CET
https://community.oracle.com/thread/839324