OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Import & export

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

Import & export [message #111940]

Tue, 22 March 2005 00:18

ravimkumar
Messages: 5
Registered: March 2005

Junior Member

I have a database in which i have arabic data. When i exported and imported to another database all arabic data became '????????????'

Report message to a moderator

Re: Import & export [message #111964 is a reply to message #111940]

Tue, 22 March 2005 02:02

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Seems to be that the destination DB has another codeset ?
Did you proof the NLS Variables ans settings in both databases ?

Uwe

Report message to a moderator

Re: Import & export [message #112058 is a reply to message #111964]

Tue, 22 March 2005 13:11

ravimkumar
Messages: 5
Registered: March 2005

Junior Member

Yes there was a problem in characterset. The sourse had AR8ISO8859P6 and the destination had WE8ISO8859P1. I even tried this

Login to oracle Database server as sys privilege

SQLPLUS> connect sys/change_on_install as sysdba;
SQLPLUS> shutdown immediate;
SQLPLUS> startup mount;
SQLPLUS> alter system enable restricted session;
SQLPLUS> alter system set job_queue_processes=0;
SQLPLUS> alter system set aq_tm_processes=0;
SQLPLUS> alter database open;
SQLPLUS> alter database orcl national character set AR8ISO8859P6;

error ---You can't change character set of the current database that have number of bits greater than the new one

Please suggest how to change the characterset.

Report message to a moderator

Re: Import & export [message #112114 is a reply to message #112058]

Wed, 23 March 2005 02:03

Maaher
Messages: 7065
Registered: December 2001

Senior Member

DB version? Exact error message?

MHE

Report message to a moderator

Previous Topic:	How to export the Schema including all_directories??????
Next Topic:	copy .ORA and .DBF to other places/disk-partition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 22:04:43 CDT 2024