DBMS_DATAPUMP API equivalent of EXCLUDE=grants

From: <bclark76_at_gmail.com>
Date: Tue, 8 Apr 2008 07:09:30 -0700 (PDT)
Message-ID: <f5ad0d87-2fdc-4d6d-a8d4-b0598a2f63c5@a1g2000hsb.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. Received on Tue Apr 08 2008 - 09:09:30 CDT

Original text of this message