Skip to Main Content
Forums

Oracle Database Discussions

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!

Database Migration

user3308982May 23 2010 — edited May 23 2010
Hi




I migrated oracle9i database to oracle10g using exp/imp utility,after migration hardcoded arabic characters not displaying properly and privilages are not migrating properly what could be the reason ?




for exp(Oracle9i) i used below

EXP SYSTEM/xxx@xxx BUFFER=40960000 FILE=db01.DMP GRANTS=Y INDEXES=Y STATISTICS=NONE LOG=db01.LOG ROWS=Y CONSISTENT=Y FULL=Y CONSTRAINTS=Y OBJECT_CONSISTENT=Y


For Imp (oracle10g) utillity i used

imp system/xxx@xxx file=db01.dmp log=impdb01.log full=y


import successfully terminated with warnings


Thanks

With Regards
OH
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2010
Added on May 23 2010
#export, #general-database-discussions
3 comments
959 views