ORA-12899 in import [message #486165] |
Tue, 14 December 2010 01:46  |
dba_7722
Messages: 197 Registered: August 2010 Location: Delhi
|
Senior Member |

|
|
Hello Export,
ORA 12899 prompts when we are doing import from 10.2.0.3 -> 11g R2.
Also it is cross platform, AIX -> windows 2003.
Please suggest for corrective action.
Regards,
JAY VARDHAN
|
|
|
Re: ORA-12899 in import [message #486171 is a reply to message #486165] |
Tue, 14 December 2010 02:06   |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
12899, 00000, "value too large for column %s (actual: %s, maximum: %s)"
// *Cause: An attempt was made to insert or update a column with a value
// which is too wide for the width of the destination column.
// The name of the column is given, along with the actual width
// of the value, and the maximum allowed width of the column.
// Note that widths are reported in characters if character length
// semantics are in effect for the column, otherwise widths are
// reported in bytes.
// *Action: Examine the SQL statement for correctness. Check source
// and destination column data types.
// Either make the destination column wider, or use a subset
// of the source column (i.e. use substring).
Same character set?
Post both NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET values from nls_database_parameters in both databases.
Regards
Michel
[Updated on: Tue, 14 December 2010 02:06] Report message to a moderator
|
|
|
|
|
|
|
|
|