Datapump Questions

   I've been trying to use data pump for the first time. I've read through the 11g documentation. My problem is that I need to be able to move data from a 10g (10.2.0.4) database to an 11g (11.2.0.1) database. I can do the datapump export on the 10g side, copy the file to the 11g server, and import it into 11g. What is needed is to be able to either remotely execute datapump from the 11g side or to be able to do a direct import, again initiating it from the 11g side. I've tried both and I keep getting errors that I can't find good documentation on to help me figure out what is wrong.

   In doing the direct import, I get the following errors: ORA-31631: privileges are required
ORA-39149: cannot link privileged user to non-privileged user

   In my test case, I have control over the users on both sides. For the real conversion, I won't. I've granted the 11g user the DATAPUMP_EXP_FULL_DATABASE and DATAPUMP_IMP_FULL_DATABASE roles. On the 10g side, those roles don't exist, so I granted the user EXP_FULL_DATABASE and IMP_FULL_DATABASE. I've granted the same system roles (connect and resource) to both sides. I am not running datapump as sys or system.

  In doing the remote export, I get the following error: UDE-00018: Data Pump client is incompatible with database version 10.2.0.4.0

   I tried setting the version parameter to 10.2.0.4 in the parfile, but that didn't help. I thought that you could use a higher version of expdp / impdp (11g vs. 10g database). I don't have a 10g environment on the 11g side to use.

   I've tried googling all of these errors and have done everything that I can find and nothing changes.

Has anyone been able to get this to work? If so, how did you do it?

Thank you,

Scott Canaan '88 (srcdco_at_rit.edu<mailto:Scott.Canaan_at_rit.edu>) (585) 475-7886 - work
"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.

--
http://www.freelists.org/webpage/oracle-l