datapump import errors, please help now, thanks

Printable View

11-12-2008, 03:30 AM
mdvreddy

datapump import errors, please help now, thanks

Hi,

could you plz help me to solve below errors which are coming while doing import with impdp command in oracle 10g 10.1.0.4.0 os: Red Hat Enterprise Linux ES release 4

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Job "DCA"."SYS_IMPORT_SCHEMA_01" stopped due to fatal error at 15:31

i tried to restart job but the following errors coming

UDI-00008: operation generated ORACLE error 39078
ORA-39078: unable to dequeue message for agent KUPC$A_1_20081111155728 from queue "KUPC$C_1_20081111155728"
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2356
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3261
ORA-06512: at line 1

thanks in advance
11-12-2008, 10:11 AM
LKBrwn_DBA

Characterset

Check for characterset conversions (NLS_LANG environment variable). ;)
11-13-2008, 05:17 AM
mdvreddy

echo $NLS_LANG
american_america.utf8
11-13-2008, 09:31 AM
LKBrwn_DBA

Ethnic characters?

Quote:

Originally Posted by mdvreddy

echo $NLS_LANG
american_america.utf8

Did you check against the database characterset? this normally happens when the source data has "special" (read ethnic) characters that are translated into two character pairs on import and no longer "fit" into the original column size.
:p
11-13-2008, 11:13 AM
mdvreddy

Quote:

Originally Posted by LKBrwn_DBA

Did you check against the database characterset? this normally happens when the source data has "special" (read ethnic) characters that are translated into two character pairs on import and no longer "fit" into the original column size.
:p

all nls_database parameter values are same on both source and destination db systems. any solutions to this problem?
11-13-2008, 11:34 AM
PAVB

Don't you have access to Metalink?

This is related to small STREAMS_POOL_SIZE

Set it to 100M then recycle the database and try again.