import to different user with the new correct grant doesn't work

From: Bryce <brice.dutheil_at_gmail.com>
Date: 15 Dec 2006 06:06:38 -0800
Message-ID: <1166191597.903668.306150@n67g2000cwd.googlegroups.com>

Hi,

I have a problem with the import util from oracle (Import: Release 10.2.0.1.0 - Production on Fri Dec 15 14:45:49 2006).

I would like to import from 2 schemas to 2 different schema, and the import tool works fine exept for the grantas that it sets to the original user.

adminuser (grants select, insert, etc to realuser) realuser (got grants from adminuser)

imp userid=sys/sys fromuser=adminuser,realuser touser=testadminuser,testuser

All the schemas are on the same database server.

And once my import is done, testuser didn't get anygrant to TESTADMINUSER objects while REALUSER now have grants from ADMINUSER and from TESTADMINUSER)

Is there a way to import related schemas into the same schemas named differently. Received on Fri Dec 15 2006 - 08:06:38 CST