Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
DBMS_DATAPUMP API equivalent of EXCLUDE=grants
1,784 views
Skip to first unread message
bcla...@gmail.com
Apr 8, 2008, 10:09:30 AM4/8/08
to
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.
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.
miste...@gmail.com
Feb 20, 2015, 8:24:29 AM2/20/15
to
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!
Eric
Feb 20, 2015, 2:40:12 PM2/20/15
to
On 2015-02-20, miste...@gmail.com <miste...@gmail.com> wrote:
firured it out or given up a long time ago.
Eric
--
ms fnd in a lbry
> On Tuesday, April 8, 2008 at 3:09:30 PM UTC+1, bcla...@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>< -------
>> 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.
>> 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
>
> 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!
firured it out or given up a long time ago.
Eric
--
ms fnd in a lbry
Noons
Mar 4, 2015, 6:47:02 PM3/4/15
to
On Saturday, February 21, 2015 at 6:40:12 AM UTC+11, Eric wrote:
>
> Good work answering a mesaage from 2008, I suspect they have either
> firured it out or given up a long time ago.
>
LOL!
>
> Good work answering a mesaage from 2008, I suspect they have either
> firured it out or given up a long time ago.
>
Amazing the frame of mind of what passes for "techos" nowadays...
rl...@utec.edu.pe
Mar 14, 2019, 10:14:19 AM3/14/19
to
This worked for me:
DBMS_DATAPUMP.METADATA_FILTER(l_dp_handle,
'EXCLUDE_PATH_EXPR',
'IN (''GRANT'')');
--
La información contenida en este e-mail y sus anexos es confidencial,
privilegiada y está dirigida exclusivamente a su destinatario, en
consecuencia, solo puede ser utilizada por aquel. Si usted no es el
destinatario original, no deberá examinar, usar, copiar o distribuir este
mensaje o la información que contiene. Si lo recibe por error, por favor
reenvíelo a la persona que se lo envió y elimínelo. Cualquier retención o
uso total o parcial no autorizada de este mensaje está estrictamente
prohibida y sancionada por ley.
0 new messages