OraFAQ Forum: Server Utilities » ORA-1882 on Import Oracle 9.2.0.6

Home » RDBMS Server » Server Utilities » ORA-1882 on Import Oracle 9.2.0.6

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

ORA-1882 on Import Oracle 9.2.0.6 [message #234145]

Mon, 30 April 2007 03:05

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

Senior Member

Hi all,

I just browse through this forum, but I do not found any hint to help me on this problem.

I just exported a Database (9.2.0.6) from one Server and try to import it on user levelon a second Server also 9.2.0.6.

Import brings me
IMP-00058: ORACLE error 1882 encountered
ORA-01882: timezone region not found
IMP-00009: abnormal end of export file
IMP-00000: Import terminated unsuccessfully

Export :
JServer Release 9.2.0.6.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

Import:
JServer Release 9.2.0.6.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

so the Char-sets seems to be equal

Any quick help is welcome
regards
Uwe

Report message to a moderator

Re: ORA-1882 on Import Oracle 9.2.0.6 [message #234209 is a reply to message #234145]

Mon, 30 April 2007 08:16

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

May be the file is corrupted.
Did you transfer the file from machine-to-machine?
Did you set proper FTP options?
Can you reproduce the case (taking a new export and doing it again?)

Report message to a moderator

Re: ORA-1882 on Import Oracle 9.2.0.6 [message #235568 is a reply to message #234209]

Mon, 07 May 2007 04:12

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

Senior Member

Thanks,

it was really a corruption Problem cause we have to copy through a windows environment and it switched from binary to ascii¨

regards
Uwe

Report message to a moderator

Previous Topic:	Importing from dmp file problem
Next Topic:	SQL*Loader-704: Internal error: ulmtsyn: OCIStmtExecute(tabhp) Ý1480¨

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 11:47:04 CST 2024