OraFAQ Forum: Server Utilities » Import failed from 9.2 to 8.1.7 ( URGENT )

Home » RDBMS Server » Server Utilities » Import failed from 9.2 to 8.1.7 ( URGENT )

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

Import failed from 9.2 to 8.1.7 ( URGENT ) [message #120285]

Wed, 18 May 2005 15:53

sridcpp
Messages: 23
Registered: February 2005
Location: India

Junior Member

While importing data from 9.2 version to 8.1.7 its getting failed. It gives NLS errors...

please suggest.

thanks

Report message to a moderator

Re: Import failed from 9.2 to 8.1.7 ( URGENT ) [message #120289 is a reply to message #120285]

Wed, 18 May 2005 16:35

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

Senior Member
Account Moderator

out of 100 possible errors reported here
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96525/impus.htm#357414
Which one are you talking about?

PLEASE always POST the complete error message.
I guess,
your NLS_LANG or characterset is different between source and target.
Set it manually in your environment and do the import.

or

Issue is becuase of the difference in versions.
You trying import from 9i into 8i.
Use the lower version of exp to export.
use the lower version of imp to import.
else
run catexp.sql of 9i installation agains your 8i installation and then run your import.

Report message to a moderator

Previous Topic:	dynamic infile
Next Topic:	When clause in Sql*Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 12:40:33 CST 2025