Home » RDBMS Server » Server Utilities » Import errors (10.2.0.4, Windows 2003)
Import errors [message #425963] Tue, 13 October 2009 07:27 Go to next message
pleasehelp
Messages: 21
Registered: January 2007
Junior Member
Hi,

I just imported client's data into our database, but got several rows rejected during the import and several objects are invalid..

Export was done in 10.2.0.1, WE8MSWIN1252 character set and AL16UTF16 NCHAR character set..

Import was done in 10.2.0.4, WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)

Is there a way to fix this issue just to import this data? I cannot change the character set because there are several other users using this database.. But is it possible to change the character set during the import session only?

Please help me..Thanks
Re: Import errors [message #425968 is a reply to message #425963] Tue, 13 October 2009 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is just an information message, in your case it does not matter as your target database character contains all characters of your source one and there was no conversion due to client setting.

Regards
Michel
Re: Import errors [message #425970 is a reply to message #425963] Tue, 13 October 2009 07:49 Go to previous messageGo to next message
pleasehelp
Messages: 21
Registered: January 2007
Junior Member
Thanks Michel..

But then I've been getting several of these errors:

IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column

Isnt it due to the character set difference? Target database being Unicode?

THanks
Re: Import errors [message #425978 is a reply to message #425970] Tue, 13 October 2009 08:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is another point.

AL32UTF8 is a variable length character set, each character can be on 1 to 3 bytes.
You have to either:
- change the definition of each (var)char columns from a byte one to a char one
- enlarge all fields that may contain characters that are not in 0-127 code points.

Regards
Michel
Re: Import errors [message #426244 is a reply to message #425963] Wed, 14 October 2009 09:57 Go to previous messageGo to next message
pleasehelp
Messages: 21
Registered: January 2007
Junior Member
Thanks Michel.

Can this issue be resolved if use Data pump export and import?
Will it work fine if I use data pump export and import to unicode database?

Thanks
Re: Import errors [message #426249 is a reply to message #426244] Wed, 14 October 2009 10:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The issue is independent of the tool you will it is inherent of the data.
You ONLY have the 2 options I mentioned. Oh Yes, you have a third one: don't import the offended data.

Regards
Michel
Re: Import errors [message #426264 is a reply to message #426249] Wed, 14 October 2009 11:03 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


I recommend you need to use Character Set Scanner Utility (CSSCAN) before import.

Thanks
Re: Import errors [message #426266 is a reply to message #426264] Wed, 14 October 2009 11:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is useless, he already knows the answer: some fields are too small for the data.

Regards
Michel
Re: Import errors [message #426471 is a reply to message #426264] Thu, 15 October 2009 10:27 Go to previous messageGo to next message
pleasehelp
Messages: 21
Registered: January 2007
Junior Member
Oh ok.

CSSCAN - is it like a command before I run the import into unicode database? Will it convert the data by itself?

Thanks much
Re: Import errors [message #426472 is a reply to message #426471] Thu, 15 October 2009 10:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, csscan just verifies where there can be a problem when (for example) you import from a character set to another one.
In your case, you already know where is the problem as you already got the error.

Regards
Michel
Re: Import errors [message #426481 is a reply to message #426472] Thu, 15 October 2009 14:45 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Okay. If you know which fields are too small for the data then no need csscan. if no then go with csscan.

Babu
Previous Topic: Error while Exporting data
Next Topic: Import stalled with 'SQL*Net message from client' wait event
Goto Forum:
  


Current Time: Fri Dec 09 15:15:33 CST 2016

Total time taken to generate the page: 0.16452 seconds