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!

Impdp remapping user doesn't change view definitions

kirkladbAug 12 2013 — edited Aug 12 2013

Is there anyway to get the view definitions to point to the new schema after a database export/import via datapump? i.e: If I have view in the source db called user1.test (DDL: select empno, empname from user1.emp) and I do an export and then import it via datapump remapping user1 to user2. Now the user2 view is called user2.test (DDL: select empno, empname from user1.emp) Which is wrong. Any help, appreciated

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2013
Added on Aug 12 2013
2 comments
852 views