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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

sb92075
user13375747 wrote:
We want to migrate an Oracle database from windows(11.2.0.1) to Linux(11.2.0.1). What are my options? DB size is 300 GB.

Thanks
expdp/impdp
RMAN

Handle: user13375747
Status Level: Newbie
Registered: Sep 14, 2011
Total Posts: 9
Total Questions: 8 (7 unresolved)

why so many unanswered questions?
Srini Chavali-Oracle
Pl see options outlined in this MOS Doc

Migration Of An Oracle Database Across OS Platforms [ID 733205.1]

HTH
Srini
864103
use transport tablespace and the below link is step by step :

http://www.scribd.com/doc/19806164/Transport-tablespace-from-one-database-to-another

thanks
1 - 3
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
931 views