Re: Data Pump and GRANTs
From: gazzag <gareth_at_jamms.org>
Date: Thu, 17 Jun 2010 07:37:45 -0700 (PDT)
Message-ID: <a5fe94ab-e2e4-4e12-b826-2e1225e16b57_at_u7g2000yqm.googlegroups.com>
On 17 June, 15:13, "Syltrem" <syltremz..._at_videotron.ca> wrote:
>
> Exporting and importing with user IVADBA
>
> All the ORA-39082: errors in the IMPORT job are because of GRANTS not being
> granted to the imported user. These objects can`t compile because of the
> missing privileges for objects in other schemas.
<snip>
Date: Thu, 17 Jun 2010 07:37:45 -0700 (PDT)
Message-ID: <a5fe94ab-e2e4-4e12-b826-2e1225e16b57_at_u7g2000yqm.googlegroups.com>
On 17 June, 15:13, "Syltrem" <syltremz..._at_videotron.ca> wrote:
>
> Exporting and importing with user IVADBA
>
> All the ORA-39082: errors in the IMPORT job are because of GRANTS not being
> granted to the imported user. These objects can`t compile because of the
> missing privileges for objects in other schemas.
<snip>
I wonder if metadata filtering is playing a role in this:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#i1009903
HTH
-g
Received on Thu Jun 17 2010 - 09:37:45 CDT