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

unknown-698157
The primary reason is
Not reading documentation
As a result
either the character set of the database is incorrect
or
NLS_LANG was incorrect during export or import.

------
Sybrand Bakker
Senior Oracle DBA
Lubiez Jean-Valentin
Hello,
after migration hardcoded arabic characters not displaying properly and privilages are not migrating properly what could be the reason ?
Did you get any message which warms you that there's a possible characterset conversion ?

The easiest way is to migrate your datas into a target database which has the same characterset than the source one. Else, you may care about characterset migration. For instance, you can migrate from US7ASCII to WE8MSWIN1252, ... some charactersets are compatible some other not.

More over, as previously posted, if the NLS_LANG is not well set, it can prevent a correct conversion.

You may have more details on the following link:

http://download.oracle.com/docs/cd/B28359_01/server.111/b28298/ch11charsetmig.htm#CEGCGEAF

About the Privilege, it would be nice that you post the error message. May be, you need to create first a User on the database so as to be able to Grant him the Object Privileges during the Import.


Hope this help.
Best regards,
Jean-Valentin
sb92075
after migration hardcoded arabic characters not displaying properly
One of two reasons are why this occurs
1) data in the new DB is not correct
2) data in the new DB is correct & a data presentation problem exists

You can determine which is the case by issuing simple SELECT as below.

SELECT ASCII_STR(<arabic_column>) from ARABIC_TABLE;

Examine result set to determine is correct data is actually in the DB.
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
942 views