Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

remap_schema

ChristianApr 9 2015 — edited Apr 11 2015

Hey, I have several database users in the users tablespace.

Now I like to import those users into a new dev database.

So I use exdp to export all these users.

In the import process with impdp I use the remap_schema command.

The users are created fine, but while importing, there are several grants where it tries to grant rights to a username of the productive database and NOT of the new username which will something like users_newDEVdatabase

Any way to avoid this ? Or get this fixed ?

ORA-39083,ORA-01917

Chris

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2015
Added on Apr 9 2015
7 comments
1,536 views