OraFAQ Forum: Server Administration » Oracle 8.17 Import problem (Character set issue)

Home » RDBMS Server » Server Administration » Oracle 8.17 Import problem (Character set issue)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 8.17 Import problem (Character set issue) [message #176613]

Thu, 08 June 2006 22:17

hillhui
Messages: 3
Registered: June 2006

Junior Member

I am trying to export the the database from instance "A" to Instance "B".

And there are some chinese character in Instance "A" which can successfully displayed by our application.

But when we export Instance A and then import this DMP file to Instance B, these chinese character cannot be displayed. but there are no error messages during the export and import process.
And both Instances are stored in the same machine.

Is there are some steps I have missed during the export and import process?

Thx

Report message to a moderator

Re: Oracle 8.17 Import problem (Character set issue) [message #176621 is a reply to message #176613]

Fri, 09 June 2006 00:08

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Are the NLS settings equal in both instances?

Report message to a moderator

Re: Oracle 8.17 Import problem (Character set issue) [message #176633 is a reply to message #176613]

Fri, 09 June 2006 00:48

hillhui
Messages: 3
Registered: June 2006

Junior Member

yes, I have already checked it.

Report message to a moderator

Re: Oracle 8.17 Import problem (Character set issue) [message #176658 is a reply to message #176613]

Fri, 09 June 2006 01:54

hillhui
Messages: 3
Registered: June 2006

Junior Member

But there is NLS value which appear in Instance B only.

NLS_CSMIG_SCHEMA_VERSION=3

This values is queried by
select * from nls_database_parameters;

and what does it means?

[Updated on: Fri, 09 June 2006 01:55]

Report message to a moderator

Previous Topic:	Char(10) vs Varchar2(10)
Next Topic:	Oracle Not available

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:22:35 CDT 2024