Import DataPump ORA-39083 PLS-103 When Importing Statistics Created With Non "." NLS Decimal Character (Doc ID 278937.1)

Last updated on NOVEMBER 28, 2016

Symptoms

Oracle10g Import DataPump fails to import table statistics. The output in the log file shows:

...
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39083: Object type TABLE_STATISTICS failed to create with error:
ORA-06550: line 1, column 332:
PLS-00103: Encountered the symbol "," when expecting one of the following:
( - + case mod new not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pip
...

Other possible error:

PLS-00306: Wrong number or types of arguments in call of 'SET_COLUMN_STATS'

Changes

You recently upgraded the database to Oracle10g, Release 1, 10.1.0.2.0 and are using Export DataPump and Import DataPump.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms